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

Learn Vlookups - You'll never regret the time you spend. See below:

http://contextures.com/xlFunctions02.html


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532126

Hi!

Try this:

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

Biff

"C Anderson" wrote in message
...
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

You've got a response to
your multi-post in .worksheet.functions
(Please do not multi-post)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

try this, first , you put the following in column A ,columnB

A B
Townsville 1
Sydney 2
Brisbane 3

if you have the text in cell C1 ,and value in D1,
then you can write the formula as :
=CHOOSE(VLOOKUP(C1,A1:B3,2),0.36%*35/25,0.44%*35/25,0.44%*50/25)*D1

Wdjsxj


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