Help fixing a formula

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still need help with IF and Count Function 11
Need Help with Substitute Formulas, etc. 5
Help on an IF formula 3
Need to stop VLOOKUP formula changes 2
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
Iserror help 3
Help with another formula, please 3
Is Error Help on a formula 5

Top