View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Haz Haz is offline
external usenet poster
 
Posts: 46
Default 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