I am having a problem with the following function:

=ROUNDUP((C5*C4),2)

Upon entering the above the cell shows: "#VALUE!" when cell C4 is
empty. I would like it to show zero when cell C4 is empty.


--
brown_toby
------------------------------------------------------------------------
brown_toby's Profile: http://www.excelforum.com/member.php...o&userid=35942
View this thread: http://www.excelforum.com/showthread...hreadid=557416

=IF(C4="",0,=ROUNDUP((C5*C4),2))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"brown_toby" wrote
in message ...

I am having a problem with the following function:

=ROUNDUP((C5*C4),2)

Upon entering the above the cell shows: "#VALUE!" when cell C4 is
empty. I would like it to show zero when cell C4 is empty.


--
brown_toby
------------------------------------------------------------------------
brown_toby's Profile:
http://www.excelforum.com/member.php...o&userid=35942
View this thread: http://www.excelforum.com/showthread...hreadid=557416

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))

"brown_toby" wrote:


I am having a problem with the following function:

=ROUNDUP((C5*C4),2)

Upon entering the above the cell shows: "#VALUE!" when cell C4 is
empty. I would like it to show zero when cell C4 is empty.


--
brown_toby
------------------------------------------------------------------------
brown_toby's Profile: http://www.excelforum.com/member.php...o&userid=35942
View this thread: http://www.excelforum.com/showthread...hreadid=557416

I can't duplicate your error...

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=557416