| =IF(Z14<=15000,Z14*1.75%,0) |
Hai ramesh i have given the formula for Rounding off using if function
=IF(F10<=15000,ROUND(F10*1.75%,-1),0)
Regards
Dheena
Hiii,u can use dis one also,& can change "-1" by 0 or 1 according to ur requirement.
=ROUND((IF(Z14<=15000,Z14*1.75%,0)),-1)
Right you can use the formula as given by Rknahar.
Given following example:
| 5000 | 1.75 | =ROUND(IF(I24<=5000,5000*1.75,0),0) |
This will resulted as under:
| 5000 | 1.75 | 8750 |
Here you are using two formula simultaneously. If you want to use round formula,then you have to first put word "Round" in the first space then you can use any other formula.
Hope it will clear your doubt and it will be useful to you.
CCI
Pro
CAclubindia
