rounding down another cell with a formula

[Steve]

cell j34 -> =IF(Input!K15>0,AVERAGE(J22+J33)/2,"")

This part works ok, putting the number in cell j34, or nothing.
However, I need the cell in j35 to rounddown 2 places the value in j34 if
it's >0, but also put nothing the j35 if there's nothing in j34.

I'm trying by using the =ROUNDDOWN(J34,2), but I'm getting an error.

Any help would be appreciated.

Thanks,

Steve

[Bob Phillips]

Try

=IF(J34="","",ROUNDDOWN(J34,2)

Also the AVERAGE in the other formula seems superfluous.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve" <[email protected]> wrote in message
news:[email protected]...
> cell j34 -> =IF(Input!K15>0,AVERAGE(J22+J33)/2,"")
>
> This part works ok, putting the number in cell j34, or nothing.
> However, I need the cell in j35 to rounddown 2 places the value in j34 if
> it's >0, but also put nothing the j35 if there's nothing in j34.
>
> I'm trying by using the =ROUNDDOWN(J34,2), but I'm getting an error.
>
> Any help would be appreciated.
>
> Thanks,
>
> Steve

[wjohnson]

This seemed to work:
=IF(Input!K15>0,ROUNDDOWN((J22+J33)/2,2),"")

[Steve]

Thanks guys,

Both worked nicely. So simple. Boy, do I feel stoopid.

Thanks again,

Steve

"wjohnson" wrote:

>
> This seemed to work:
> =IF(Input!K15>0,ROUNDDOWN((J22+J33)/2,2),"")
>
>
> --
> wjohnson
> ------------------------------------------------------------------------
> wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
> View this thread: http://www.excelforum.com/showthread...hreadid=498724
>
>