Hi Jonathin,
I think you have a zero missing from your second IF thingy.
You have 150000, and I think it should be 1500000
Regards - Dave.

"Jonathan Cheek" wrote:

I have been trying to make a formula that will out put a certain percentage
for the numbers I input. for example if i put 2,000,000 in Cell A16 I want it
give me 3% in Cell B16. This is the complex formula that i came up with

=IF(A16=2000000,3%,IF(AND(A16=150000,A16<2000000 ),4%,IF(AND(A16=1000000,A16<1500000),4.5%,IF(AND( A16=600000,A16<1000000),5%,IF(AND(A16=450000,A16 <600000),5.5%,IF(A16<450000,6%,0))))))

Every time i use this formula, I doesn't give me the right percentages if I
input anything under 150,000,000. For example if I input the number 600,000
then i should return me the percentage of 5%. However when i attempt this,
the output percentage will always be 4%. to me this means that only
this portion is functional:

=IF(A16=2000000,3%,IF(AND(A16=150000,A16<2000000 ),4%

If anyone can find out what I'm doing wrong. I would mean a world of help
for me.