Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc.

[larevalo71]

Hello All !! I have an excel file that has numbers 0 thru 100 in Column "L". I need to convert 1 to .05 or 2 to .10 or 3 to .30 or 4 to .50 and so on. All the way up to 100 = 15.00. All saving in the same column?. Can someone please point me in the right direction..

 

[Becky]

Welcome to the forum

What logical progression do the numbers follow once converted? ie how are they determined?

Also, when you say you want them 'saving in the same column' do you mean you want to replace the existing data (1-100)?

 

[larevalo71]

 

[larevalo71]

I need to change the numbers to the currency value associated with it.

 

[Becky]

That doesn't tell me how the starting number relates to the end number... I'm going to need a little more to go on here. How are the currency numbers determined?