Hello!
I am hoping someone can help me. Basically, I am trying to have a percentage populate based on the number within a cell. I run into issues with the multiple arguments. This is what I am trying to accomplish...
Anything less than 57000 = 5%
Greater than 57001 but less than 84000 = 4%
Greater than 84001 but less than 150000=3.5%
And anything over 150,999 is 3%
=if(C3>=57000,5%,if(and(C3<=57001,C3>=84000,4%)))
I'm just lost, please help
I am hoping someone can help me. Basically, I am trying to have a percentage populate based on the number within a cell. I run into issues with the multiple arguments. This is what I am trying to accomplish...
Anything less than 57000 = 5%
Greater than 57001 but less than 84000 = 4%
Greater than 84001 but less than 150000=3.5%
And anything over 150,999 is 3%
=if(C3>=57000,5%,if(and(C3<=57001,C3>=84000,4%)))
I'm just lost, please help