J
Jonathan Cheek
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.
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.