I need the cell to prompt me...

[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

 

[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")))

 

[jbf frylock]

I'll try it. Thanks Dave.