View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sojuman sojuman is offline
external usenet poster
 
Posts: 9
Default Lookup Statement (2007)

I have a spreadsheet users will be entering monthly mileage readings into.
Column D could have a value of M (miles) or K (kilometers). If K is used, I
would like it to convert the difference between the starting and ending
readings into miles.

D9 = K
H9 = Starting kilometers (45612)
I9 = Ending Kilometers (45700)
J9 = resulting difference in miles (I9-H9)*.6 result (52.8 miles)

Is this possible.

Thanks