I need the cell to prompt me...

J

jbf frylock

I have an IF statement for an income eligibility guideline...
=IF(D10<=(A10*'Income Eligibility Guidelines'!D2+'Income Eligibility
Guidelines'!D1),"Free",IF(D10<=(A10*'Income Eligibility
Guidelines'!E2+'Income Eligibility Guidelines'!E1),
"Reduced","Paid"))

This formula is used only for data that is in different income
frequencies...monthly, annually and let's say bi-weekly. This will add and
multiply all of these incomes to one annual income. If there are multiple
incomes in one frequency though...just monthly...and lets say there are 3
incomes, I need the cell with the above formula to say "See Guideline Chart".
Can I add a formula to this one to prompt this response?

Hope it is clear enough...thanks in advance

jbf frylock
 
D

Dave O

You already know about nested IF statements- you might add an IF to
your existing formula that says IF(one frequency, 3 incomes,"See
Guideline Chart",IF(D10<=(A10*'Income Eligibility
Guidelines'!D2+'Income Eligibility
Guidelines'!D1),"Free",IF(D10<=(A10*'Income Eligibility
Guidelines'!E2+'Income Eligibility Guidelines'!E1), "Reduced","Paid")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top