| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula result incorrect
i have this formula
{=IF(W15="Within Range","",(H4:I39)*W16)} my range H4:I39 actually equals 101670.50, and W16 is a formula w the result of 10%. so the formula result should be 10% of 101670.50, but it returns 303.75, which is about .2%. this has come back across the board and im not sure why any help greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
