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.
- Just tried this and its bring back a value error.
That's surprising. Can you open the attached pdf file? The formula seems to work in my spreadsheet.
- I will try to open the files when I get home this evening my company blocks certain outside content. I will try it again and let you know what happens. Thanks again
- Thank you, unfortunately my work computer will not allow me open the example you sent but I will test the formula to see if it works
