if function help
 

hi,
I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent east/west and tower in
cells as E - W -T and do this calc.


east =2 15
west=1.86 16
tower=2 17

Hope this makes sense
Thanks

Haz

if function help
 

Something like:

=F15/INDEX({2,1.86,2},MATCH(E15,{"E","W","T"},0))

Hope this helps.

Pete

On May 21, 8:37*am, Haz wrote:
hi,
I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent east/west and tower in
cells as E - W -T and do this calc.

east =2 * * 15
west=1.86 * * * * * 16
tower=2 * * 17

Hope this makes sense
Thanks

Haz

if function help
 

You have an answer elsewhere - please do not multi post.

Pete

On May 21, 8:37*am, Haz wrote:
hi,
I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent east/west and tower in
cells as E - W -T and do this calc.

east =2 * * 15
west=1.86 * * * * * 16
tower=2 * * 17

Hope this makes sense
Thanks

Haz

if function help
 

Sorry, my mistake.

Pete

On May 21, 9:26*am, Pete_UK wrote:
You have an answer elsewhere - please do not multi post.

Pete

On May 21, 8:37*am, Haz wrote:



hi,
I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent east/west and tower in
cells as E - W -T and do this calc.

east =2 * * 15
west=1.86 * * * * * 16
tower=2 * * 17

Hope this makes sense
Thanks

Haz- Hide quoted text -

- Show quoted text -