how do I add round to a IF statement?
Well, if C8 does equal zero, then C8*J8 will also equal zero, so your
formula could be written as:
=IF(C8=0,0,J8)
Did you mean to write:
=IF(C8=0,J8,J8*C8)
?
Anyway, to round it to 2 decimal places, for example, you can just put
ROUND around your formula (whichever it is) like this:
=ROUND(your_formula,2)
Hope this helps.
Pete
On Sep 2, 12:51*am, Kelly Ditsworth <Kelly
wrote:
I have the following formula and I want to round the same cell. *Is this
possible?
=IF(C8=0,C8*J8,J8)
|