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

L

larevalo71

Joined
Apr 5, 2017
Messages
3
Reaction score
0
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..
 
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)?
 
WIS 1.webp
WIS 2.webp
 
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?
 
Back
Top