Multiple Formulas in same Cell

[C Anderson]

I am having trouble trying to make a formula work.

what I am trying to do is this. I have text in one cell ie Townsville,
Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet
to take the value from an adjacent cell and *0.44%*50/25. If the value of
the cell is Townsville then I need the worksheet to take the value from the
adjacent cell and *0.44%*35/25. If the value is anything else I need the
worksheet to take the value from the adjacent cell and *0.36%*35/25

Can anyone help me with this delimar

[Bryan Hessey]

=IF(OR(A1="Brisbane",A1="Sydney"),B1&"*0.44%*50/25",IF(A1="Townsville",B1&"*0.44%*35/25",B1&"*0.44%*35/25"))

Another option is to setup a lookup table of names and addons, and use

=B1&VLookup(A1,table,2,False)

Added:

I can't believe I misread that,

=IF(OR(A1="Brisbane",A1="Sydney"),B1*0.44%*50/25,IF(A1="Townsville",B1*0.44%*35/25,B1*0.44%*35/25))

I am having trouble trying to make a formula work.

what I am trying to do is this. I have text in one cell ie Townsville,
Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet
to take the value from an adjacent cell and *0.44%*50/25. If the value of
the cell is Townsville then I need the worksheet to take the value from the
adjacent cell and *0.44%*35/25. If the value is anything else I need the
worksheet to take the value from the adjacent cell and *0.36%*35/25

Can anyone help me with this delimar

[Bob Phillips]

Bit easier to read

=B1&IF(OR(A1={"Brisbane","Sydney"}),"*0.44%*50",IF(A1="Townsville","*0.44%*3
5","*0.36%*35"))&"/25"

which can also be incorporated in the table lookup

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
>
=IF(OR(A1="Brisbane",A1="Sydney"),B1&"*0.44%*50/25",IF(A1="Townsville",B1&"*
0.44%*35/25",A1&"*0.44%*35/25"))
>
> Another option is to setup a lookup table of names and addons, and use
>
> =B1&VLookup(A1,table,2,False)
>
> C Anderson Wrote:
> > I am having trouble trying to make a formula work.
> >
> > what I am trying to do is this. I have text in one cell ie
> > Townsville,
> > Sydney, Brisbane. If I have Brisbane in the cell then I need the
> > worksheet
> > to take the value from an adjacent cell and *0.44%*50/25. If the value
> > of
> > the cell is Townsville then I need the worksheet to take the value from
> > the
> > adjacent cell and *0.44%*35/25. If the value is anything else I need
> > the
> > worksheet to take the value from the adjacent cell and *0.36%*35/25
> >
> > Can anyone help me with this delimar
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=532125
>