software

I have an IF statement for an income eligibility guideline...
=IF(D10lt;=(A10*'Income Eligibility Guidelines'!D2 'Income Eligibility
Guidelines'!D1),quot;Freequot;,IF(D10lt;=(A10*'Income Eligibility
Guidelines'!E2 'Income Eligibility Guidelines'!E1),
quot;Reducedquot;,quot;Paidquot;))

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 quot;See Guideline Chartquot;.
Can I add a formula to this one to prompt this response?

Hope it is clear enough...thanks in advance

jbf frylock

You already know about nested IF statements- you might add an IF to
your existing formula that says IF(one frequency, 3 incomes,quot;See
Guideline Chartquot;,IF(D10lt;=(A10*'Income Eligibility
Guidelines'!D2 'Income Eligibility
Guidelines'!D1),quot;Freequot;,IF(D10lt;=(A10*'Income Eligibility
Guidelines'!E2 'Income Eligibility Guidelines'!E1), quot;Reducedquot;,quot;Paidquot;)))I'll try it. Thanks Dave.

quot;Dave Oquot; wrote:

gt; You already know about nested IF statements- you might add an IF to
gt; your existing formula that says IF(one frequency, 3 incomes,quot;See
gt; Guideline Chartquot;,IF(D10lt;=(A10*'Income Eligibility
gt; Guidelines'!D2 'Income Eligibility
gt; Guidelines'!D1),quot;Freequot;,IF(D10lt;=(A10*'Income Eligibility
gt; Guidelines'!E2 'Income Eligibility Guidelines'!E1), quot;Reducedquot;,quot;Paidquot;)))
gt;
gt;