J
Jim
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,"",ROUNDUP(G52*C53,0))),0)
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,"",ROUNDUP(G52*C53,0))),0)