Thread: A1 = 200:1, B1 is 200 / 1 (200 from A1 - How to exclude :1?)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wcooke wcooke is offline
external usenet poster
  
Posts: 1
Default A1 = 200:1, B1 is 200 / 1 (200 from A1 - How to exclude :1?)
I need to figure out how to convert 200:1 in cell A1 to 200 for cell B1,
which would then be divided by 1

A1 B1
200:1 I need to exclude the :1 from 200:1 and then divide 1 by 200
for cell B, so the result would be .05

Reply With QuoteReply With Quote