Logic using IF Statements with percentages

[Chris McGlothen]

I want to write logic into the formula for Column "D". I first want to be able to Put in a manual Increase if desired into Column "E". IF I don't wan to do that then I want to put in an Increase by Percentage in Column "C".
After that I want to automatically increase Column "D" based on the logic written into "IF" statements. So it will look in Column "B" and increase Column "D" based off the ranges in the table
I don't want to use a table, just "IF" Statements. I just can't figure out how Excel sees the percentages. Any help would be appreciated. Thanks,

=IF(A2<5,5+E2,IF(E2>=0,E2+A2,IF(C2>=0*(C2+1)*A2,IF(B2>0<=25%,A2*1.05,IF(B2>25.0001%<50%,A2*1.1,IF(B2>50.0001%<100%,A2*1.15,IF(B2>100.0001<200%,A2*1.25,IF(B2>200.0001,A2*1.35,A2))))))))

[Limor_OP]

Hi,
you didnt explain what you want in columns C/D what does it manual increase.
How did you get to the numbers in column G?

[Chris McGlothen]

Columns C & D would be if I manually typed a number in. Column G are the correct numbers that I want the logic to return in Column D. So for instance Cell B5 equals 142%. Based off of the logic it should be taking the Value in Cell A5 and increasing it by 25% and that value is displayed in Cell D5.

[Chris McGlothen]

I guess what I am asking is, how should I show the percentages in the IF statements? Should it be 25% or 0.25 or 0.25%

[Limor_OP]

0.25 or 25% is the same...you can type 0.25 and format the same as %

[Chris McGlothen]

No matter what I try the correct values do not return. I know I am doing something wrong in the logic but I don't have a clue what it is. Thanks,

[protonLeah]

You are making several syntax errors. For instance, you can't say: IF(B2>0<=25%..., it's

IF(AND(B2>0,B2<=25%)...

You have: IF(C2>=0*(C2+1)*A2, 0*(C2+1)*A2 is always = zero so the IF gets False only if C2 is a negative value.

[Chris McGlothen]

protonLeah, Thanks for the reply but I'm not quite following you? I understand on the (IF(AND but not the IF(C2>=0*(C2+1)*A2, 0*(C2+1)*A2 is always = zero

[Chris McGlothen]

I figured it out. Thanks,