K
Kelly Ditsworth
I have the following formula and I want to round the same cell. Is this
possible?
=IF(C8=0,C8*J8,J8)
possible?
=IF(C8=0,C8*J8,J8)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sean Timmons
=IF(C8=0,ROUND(C8*J8,0),round(J8,0))
P
Pete_UK
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
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
K
Kelly Ditsworth
Sean: It worked like a champ. I been fighting this for quite awhile.
thanks so much!
thanks so much!
J
JoeU2004
Kelly Ditsworth said:I have the following formula and I want to round the same cell. Is this
possible?
=IF(C8=0,C8*J8,J8)
=ROUND(IF(C8=0,C8*J8,J8), 2)
The IF() example does make sense as written. But I presume it is meant to
be a paradigm, not actual functionality.