Thread
:
Determine Value based on criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
Determine Value based on criteria
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?
--
Biff
Microsoft Excel MVP
"Jan S" <Jan
wrote in message
...
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
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko