multiple criteria formula

S

Scott

I am trying to create muliple formulas for one column.

Column C - I have client Age

Column G - This is going to be any value, however if the client is younger
than 50 years of age, the max value is $15,000. If the client is above the
age of 50, the max value is $20,000.

Also, in column H, I need the max to be 4% of Column D divided by twelve
(monthly income)

Thank you

Thank you very much
 
K

kassie

to get the 4%, in H1 enter =D1*.04/12. As far as Col G is concerned, not
quite sure what you want. Is it only the two values, or are there more. If
only the 2, then use
=IF(C1="","",IF(<50,15000,20000))

If there are more options, I would suggest that you draw up a table of
possible values and criteria for each. I suppose criteria would have to be
age. You can then name this table, eg Criteria. Your formula would then be
=IF(C1="","",VLOOKUP(C1,Criteria,2,0))
 

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