Forum Discussion
Solved
Excel formula
Hello, I am seeking help to create a formula that will populate a percentage of an income based on where it falls within the federal poverty level. For example if the income in cell A1 equals 38640...
=IF(A1>=38640,A1*0.1,IF(A1>25761,A1*0.07,IF(A1>12881,A1*0.05,0)))
Is this what you want to do?
=IF(A1>=38640,A1*0.1,IF(A1>25761,A1*0.07,IF(A1>12881,A1*0.05,0)))
Is this what you want to do?
Hi, Thanks again, I was able to successfully complete the necessary calculation with the formula you provided.