Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |