rounding down another cell with a formula
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" wrote in message
...
cell j34 - =IF(Input!K150,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
|