=IF(B1="2 pack",A1/4, IF(B1="3 pack",A1/6, IF(B1="4 pack",A1/8, "not
defined")))
but you can nest max 7 IFs, and use of "" in the denominator ("4") is not
necessary, use simply 4!
Regards,
Stefi
jwfakouri ezt *rta:
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