criteria function using max

=?Utf-8?B?U2NvdHQ=?=

Guest

Posts: n/a

18th Sep 2006

I'm trying to set up a max function with two specific criteria.

In column C I have client Age

In column F I have Employee contribution

Criteria: If the client is above the age of 50, the max amount they can
contribute is 20000

If the client is below the age of 50, the max they can contribute is 15000

also, in column G, I have employer contribution. I need a formula so that
employers cannot contribute more than monthly gross income (column D/12)

Thank you very much

« Re: Can autofilter sum and average columns of numbers? Thank you | RE: Text formatting »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if function with different criteria	Haz	Microsoft Excel Misc	4	21st Oct 2008 03:56 PM
If Function. How to Add more criteria	Corey	Microsoft Excel Worksheet Functions	5	14th Jul 2006 08:57 AM
use VBA function as criteria	=?Utf-8?B?RGlhbmEgQ3Jpc2Npb25l?=	Microsoft Access Queries	3	5th May 2006 06:29 PM
Function for more than 1 criteria	rhani111	Microsoft Excel Worksheet Functions	2	12th Jul 2005 05:21 AM
Top x per criteria (Function)	JD	Microsoft Excel Misc	2	17th Jun 2004 04:54 PM