Type, should be

=A1/VLOOKUP(B1,{"2 pack",4;"3 pack",3;"4 pack",2},2,FALSE)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
=A1/VLOOKUP(A1,{"2 pack",4;"3 pack",3;"4 pack",2},2,FALSE)

just add extra conditions

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"jwfakouri" wrote
in message ...

hey everyone,
i would like to add multiple "IF's" to this formula. i need to be
able to add "3 pack" "4 pack" and so on.
thanks for your help,
jason

=IF(B1="2 pack",A1/"4")


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile:
http://www.excelforum.com/member.php...o&userid=31435
View this thread:
http://www.excelforum.com/showthread...hreadid=511675