Multiple Formulas in same Cell

C

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
 
B

Bryan Hessey

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

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
 
Top