if function help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Haz - 21 May 2008 08:37 GMT

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

Reply to this Message

Pete_UK - 21 May 2008 09:25 GMT

Something like:

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

Hope this helps.

Pete

> hi,
> I am looking for a possible If Function that will read col E, and if it is
[quoted text clipped - 11 lines]
>
> Haz

Reply to this Message

Pete_UK - 21 May 2008 09:26 GMT

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

Pete

> hi,
> I am looking for a possible If Function that will read col E, and if it is
[quoted text clipped - 11 lines]
>
> Haz

Reply to this Message

Pete_UK - 21 May 2008 09:30 GMT

Sorry, my mistake.

Pete

> You have an answer elsewhere - please do not multi post.
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

Reply to this Message