Search results

Sorry - came back one over.

Ran into a problem with the 2nd valuation =J6-SUM('2014 Expenses'!$C$6:D6) Comes back with one short. Tried to round but hit a wall everytime I changed the formula. =J6-SUM(ROUND(('2014 Expenses'!$C$6):('2014 Expenses'!D6)),0 (and every variation thereof I could imagine)

NARAYANK991, I don't know if I'm more embarrassed or proud that I arrived at the same solution upon wakening this morning. Thank you. For month 1 of 2016 will I simply be able to copy the formula from month 12 of 2015 or will I have to modify it? This is a five year forecast so there are...

I apologize for the delay in responding - to tell you the truth I simply could not get my head around either of your solutions. I did however take something from both of them to resolve my issue so thank you. Hopefully this is the last question I have: As more cities are under contract, the...

My problem is a decimal is significantly affecting my formula. The six rows in question all use the same basic formula The first problem is C6 and C7 is coverted as a decimal in the formula. That obviously affects the whole rest of the formula. I tried...

Hui, I guess your feelings got hurt since you whined and cried about my post http://chandoo.org/forums/topic/clueless-and-stressing-how-do-you-make-multiple-evaluations-in-one-formula. I posted the question about you wanting to help because it had been almost a week since I had last heard...

I'm sorry, I'm kind of thick - I tried to understand what was going on by following the evaluation but got lost so a few questions if you please.... 1)the formula you modified - what role does C2 play in the evaluation? Would I leave it and replace C6 with C7 for the hosting values? 2)what...

This is a new post off an existing one labled "how do you make multiple evaluations in a formula" from 2 days ago. I've determined that my real issue is that I'm getting inflated numbers when the formulas on rows 47-50 are evaluated. In a perfect world if there were 10 cities added or under...

I solved #3(the second #2)....

I've revised to return additional results but have questions: 1) Why in D49 the first evaluation returns 5.4 for D6? 2) How do I write the formula so as to not perform each evaluation if there are too few cities under contract?(see D49 or D50) 2) Why are the figures in row 49 (D-N) so much...

Hui, Thanks for the insight as to providing links. At first glance, that does appear to be the most logical solution - I will work with it to verify. Regarding my comments...I didn't mean to offend & I do immensely appreciate the help I get here

Hui, were you or someone else interested in helping me with my issue? I am really at a loss for how to arrive at a formula that will give me the results I need.

Sorry - I read the sticky and thought I was following the instructions but evidently not. How should I have made the file available? Hui, thanks for the response but I'm not sure I completely follow. Could you possibly walk me through what that formula is going to do?(you lost me with the...

In the attached worksheet, for the value in cell C3, I want to project how many of the cities contracted will fall into each of the categories in cells B72- B75. I would then want to multiply the corresponding value in cells C72-C75 and add the four products together to determine the projected...

Hi, I'm a bit of a novice user. In Excel 2007, I've created a dropdown list in D116 which indicates the type of action being performed: phone conversation, left voicemail, sent email, etc.. When the user begins to type into the cell or clicks on the dropdown arrow, I would like for the cell...