Roundup Function

[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 is empty. I would like it to show zero when cell C4 is empty.

[Bob Phillips]

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

--

HTH

Bob Phillips

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

"brown_toby" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[tim m]

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

[Bearacade]

I can't duplicate your error...

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