Ramesh (Manager - Finance & Accounts) (92 Points)
29 May 2010| =IF(Z14<=15000,Z14*1.75%,0) |
CA.Dheenadayalan.R
(Chartered Accountant)
(156 Points)
Replied 29 May 2010
Hai ramesh i have given the formula for Rounding off using if function
=IF(F10<=15000,ROUND(F10*1.75%,-1),0)
Regards
Dheena
Rknahar
(Rupesh Kumar Nahar)
(85 Points)
Replied 29 May 2010
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)
CA Chirag
(Chirag Sheth & Associates)
(1183 Points)
Replied 29 May 2010
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.
CAclubindia
