K Kelly Ditsworth Sep 2, 2009 #1 I have the following formula and I want to round the same cell. Is this possible? =IF(C8=0,C8*J8,J8)
P Pete_UK Sep 2, 2009 #3 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
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
K Kelly Ditsworth Sep 2, 2009 #4 Sean: It worked like a champ. I been fighting this for quite awhile. thanks so much!
J JoeU2004 Sep 2, 2009 #5 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) Click to expand... =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.
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) Click to expand... =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.
