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...
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...
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...