Determine Value based on criteria

J

Jan S

I have a spreadsheet that I need to find a value based on criteria. I have a
dollar amount that a percentage has to be applied to based on 3 different
criterias. The criteria may have multiple values to compare. For example,
column A has the dollar amount and based on Columns B,C, and D, a certain
percetage would be applied to column A.

A B C D E
$10.00 ACT or TRM <90 or >90 X,Y,Z $10.00*.35=$3.5
 
T

T. Valko

C <90 or >90

Ok, so if C does not equal 90 then it will always be <90 or >90.

D X,Y,Z

Does that mean D = X or Y or Z?
 

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