Roundup Function

  • Thread starter Thread starter brown_toby
  • Start date Start date
B

brown_toby

I am having a problem with the following function:

=ROUNDUP((C5*C4),2)

Upon entering the above the cell shows: "#VALUE!" when cell C4 i
empty. I would like it to show zero when cell C4 is empty
 
=IF(C4="",0,=ROUNDUP((C5*C4),2))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Hmmm, when I tested your formula it did give me a zero if nothing was in C4.
In any case see if the formula below helps out.

=IF(C4="",0,ROUNDUP((C5*C4),2))
 
I can't duplicate your error...

But if need be... put this in..
=IF(AND(ISNUMBER(C4),ISNUMBER(C5)),ROUNDUP((C5*C4),2),0
 
Back
Top