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?
Just tried both, both came back with errors
AD2 should contain a number, not a text value, for this to work.
And are you absolutely sure that you meant cell AD2 in your first post?
- yes, it contains a dollar amount.
What is the error you receive?
Could you attach a small sample workbook without sensitive data?
- Yes, I will have to do that once I get to a personal computer my corporation blocks a large amount of file sharing so as soon as I can I will. Thanks for your help