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 |
#2
|
|||
|
|||
Formula incorrect not result
=IF(W15="Within Range","",SUM(H4:I39)*W16) -- Regards, Peo Sjoblom (No private emails please) "Micayla Bergen" wrote in message ... 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 |
#3
|
|||
|
|||
Does this work for you:
=IF(W15="Within Range","",SUM(H4:I39)*W16) ? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Micayla Bergen" wrote in message ... 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 |
Reply |
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 |