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)

Maybe change the order of things so you're not trying to round up that ""
string:

=if(iserror(g52*c53),"",if(g52*c53=0,"",roundup(g5 2*c53,0)))

I'm not quite sure why you need that extra =round() in your formula, though.

Jim wrote:

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)

--

Dave Peterson

In your formula, you are trying to round a blank. Doesn't work. Try...
=IF(ISERROR(G52*C53),"",IF(G52*C53=0,"",ROUND(ROUN DUP(G52*C53,0),0)))
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Jim" wrote:

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)