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

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.

Ask Your Question

Weekly Poll