# IF Formulae to add percentage on output value

1. ## IF Formulae to add percentage on output value

Hi,

=IF(AND(A1>500001,A1<=750000),12500+(A1 -500000)* 10%,"No")

The result of above formulae if A1= 624000 will be 24900. To this 24900 I need to add 4% so that I get output of 25896 which I would like to divide by 12 which gives me value of 2158.

How to alter this formulae to achieve desired result

2. ## Re: IF Formulae to add percentage on output value

Maybe this:

=IF(AND(A1>500001,A1<=750000),(12500+(A1 -500000)* 10%)*0.04/12,"No")

3. ## Re: IF Formulae to add percentage on output value

No, I had tried this it gives me output of 83

4. ## Re: IF Formulae to add percentage on output value

=IF(AND(A1>500001,A1<=750000),12500+(A1 -500000)* 10%,"No")*(1.04/12)

5. ## Re: IF Formulae to add percentage on output value

=IF(AND(A1>500001,A1<=750000),12500+(A1 -500000)* 10%,"No")*(1.04/12)

This works but if value if greater than 750000 it does not return NO but returns #VALUE!

6. ## Re: IF Formulae to add percentage on output value

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

7. ## Re: IF Formulae to add percentage on output value

=IF(AND(A1>500001,A1<=750000),12500+(A1 -500000)* 10%,"No")*(1.04/12)

This works but if value if greater than 750000 it does not return NO but returns #VALUE!

8. ## Re: IF Formulae to add percentage on output value

This?

=IF(AND(A1>500001,A1<=750000),(12500+(A1 -500000)* 10%)*(1.04/12),"No")

9. ## Re: IF Formulae to add percentage on output value

=IF(AND(A1>500001,A1<=750000),(12500+(A1 -500000)* 10%)*(1.04/12),"No")

This worked. Thank You

There are currently 1 users browsing this thread. (0 members and 1 guests)