I need the cell to prompt me...
 

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

I need the cell to prompt me...
 

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

I need the cell to prompt me...
 

I'll try it. Thanks Dave.

"Dave O" wrote:

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