your first formula is working correctly, it is not necessary to dissect.
since your cells are linked to others, the source cell need to have a number
in it, an example will be K9 need to have a number. IF K9 is also a
formula, you will have to find which cell make up the formula and that there
is a number in it...all the way backward to the first cell that you input a
number.

Hope I have explained the situation.
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis









"Ann R." wrote:

Thanks for all the suggestions. I found that the below works fine IF I put
an actual number in M9, however, I currently have a formula (K9*8) in that
cell. I can go ahead and put numbers, but the point was to save having to
multiply all those different number by 8.

Does this give you all any new ideas?

"Ann R." wrote:

This is the first time I've been asked to do a formula in over a year and
since we got Vista. I have the following formula:

=IF(AND(F9=1, P9=3.5),0.654,0)*M9

In my spreadsheet F9 is 1 and P9 is 3.5, so I want it to multiply .654 by
M9. However, it is giving 0, which would be the answer if F9 was not 1 or P9
was not 3.5. I cannot see anything wrong in the formula. What am I missing?
Thanks in advance.