| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thought this was a simple formula
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Big Trouble with what I thought would be a simple Excel Formula | New Users to Excel | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Need Help with what i thought was a SIMPLE Macro | Excel Worksheet Functions | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple Formula (I thought) | Excel Worksheet Functions | |||
Threaded Mode
