# 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 formulasThis 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

#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".

Report •
Related Solutions 