Solved Rounding formula in an IF Statement

October 6, 2015 at 06:34:25
Specs: Windows 7
Can someone help me add the following rounding rules to these formulas? I know the rounding formula for nearest tenth is =ROUND(CELL,1) & for nearest whole number =ROUND(CELL,0) but am not sure where to incorporate in my formulas

This one needs to round to the nearest tenth decimal place:
=IFERROR(IF($F$3="Small",$C$21*K3,IF($F$3="Medium",$C$21*K3,IF($F$3="Large",$C$21*K3,""))),"")


This one needs to round to the nearest whole number:
=IFERROR(IF($F$3="Small",Data!$N$11*K15,IF($F$3="Medium",Data!$O$11*K15,IF($F$3="Large",Data!$P$11*K15,""))),"")

message edited by mecerrato


See More: Rounding formula in an IF Statement

Report •

#1
October 6, 2015 at 09:58:46
✔ Best Answer
Just wrap your ROUND function around any calculation that needs to be rounded:

=IF($F$3="SMALL",ROUND($C$21*K3,0),IF(...

You are still doing nothing more than calculating a value based on the result of the IF, it's just that your calculation is a bit more "complicated".

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question