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