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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History