Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help fixing a formula
Hello,
The following formula works great, except when the cell it's referencing is blank, then I receive #VALUE. What do I need to do in order to fix this issue? Thanks in advance for the help. =ROUND(IF(ISERROR(G52*C53),"",IF(G52*C53=0,"",ROUN DUP(G52*C53,0))),0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixing the header on the top | Excel Discussion (Misc queries) | |||
Fixing Last Cell | Excel Discussion (Misc queries) | |||
Fixing Hyphens | Excel Worksheet Functions | |||
Fixing a formula | Excel Discussion (Misc queries) | |||
Help with fixing formula | Excel Worksheet Functions |