Multiple Formulas in same Cell

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

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" <Bryan.Hessey.264pyy_1144808100.9221@excelforum-nospam.com>
wrote in message
news:Bryan.Hessey.264pyy_1144808100.9221@excelforum-nospam.com...
>
>
=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
>