multiple if

J

jwfakouri

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

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

Stefi

=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:
 
B

Bob Phillips

=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)
 
B

Bob Phillips

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 said:
=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)
Click to expand...
 
Top