multiple if

[jwfakouri]

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")

[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:

>
> 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
>
>

[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)

"jwfakouri" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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" <[email protected]> wrote in message
news:#[email protected]...
> =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" <[email protected]> wrote
> in message news:[email protected]...
> >
> > 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
> >
>
>