Hi
Try it this way =IF(AND(F9=1,P9=3.5),0.654*M9,0)
Best regards
John
"Ann R." <Ann wrote in message
...
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.