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?
Remove all the quotes from the formula. "..." is a text value, not a calculation.
I'd do it like this:
=AD2*IFS(A2<=12880, 0%, A2<=25760, 0.05%, A2<=38640, 0.07%, TRUE, 0.10%)
or
=AD2*LOOKUP(A2, {0, 12880, 25760, 38640}, {0%, 0.05%, 0.07%, 0.10%})
ok, thanks will try this now