Glad to help. Thanks for the feedback.

Regards,
Fred

"sojuman" wrote in message
...
All,

Thanks for all the suggestions. Works like a champ.

Tony

"Fred Smith" wrote:

In J9 you want:
=(i9-h9)*if(d9="k",0.6214,1)

Regards,
Fred

"sojuman" wrote in message
...
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

.