Thanks - worked great.
"Bob Phillips" wrote:
=A1*CHOOSE(MATCH(B1,{"d";"f";"k";"n";"v"},0),0.8,0 .85,0.9,0.75,0.7)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Mark G" wrote in message
...
I have a list that has column for pricing and a column for price code. the
price code has 1 of 5 different letters for discounts. codes are as
follows:
d,f,k,n,v. each code has a different vaule. Can I make a multiple IF
THEN
ELSE statement that would choose the correct formula? ie.. IF(code=d,
then
price*.8 else IF code=f then price*.85 else IF code=k then price*.9 else
IF
code=n then price*.75 else IF code=v then price*.7) all in one function?
--
MsG
|