Ramesh
Manager - Finance & Accounts
[ Scorecard : 92]
|
Posted On 29 May 2010 at 10:29
|
Could you pls solve the problem.
Could you tell me how do we use IF command using ROUND function, I wanted to round the following problem.
For Example
|
=IF(Z14<=15000,Z14*1.75%,0) |
Pls let me know where to insert ROUND Command here.
Regards,
Ramesh P.
|
|
|
Dheenadayalan.R
Student
[ Scorecard : 64]
|
Posted On 29 May 2010 at 10:41
|
Hai ramesh i have given the formula for Rounding off using if function
=IF(F10<=15000,ROUND(F10*1.75%,-1),0)
Regards
Dheena
Total thanks : 1 times
|
|
|
|
Rknahar
Rupesh Kumar Nahar
[ Scorecard : 85]
|
Posted On 29 May 2010 at 11:11
|
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)
|
|
|
Chirag
Account - Officer
[ Scorecard : 190]
|
Posted On 29 May 2010 at 11:51
|
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:
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.
|
|
|
