rounding down another cell with a formula

S

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
 
B

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

Steve

Thanks guys,

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

Thanks again,

Steve
 

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

Top