|
multiple if
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 |
multiple if
=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 |
multiple if
=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 |
multiple if
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 |
| All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com