Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Prompt when Cell Changes to 0 | Excel Discussion (Misc queries) | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |