I will use the actual Cells as my examples.
Situation:
M6 - Input number
O6 - Results of M6 + O6
If M6 = 0 then O6 = 0 ; If M6 = 2 then O6 = 2
If M6 = 8 then O6 = 10 ; and so on.
I want O6 to increase each time by the amount entered in M6.
Problem:
I can not find or create a formual that will do this. I'm not sure HOW to write a macro to do this either. I have tried to create a formula and each time I enter a number in M6 the result in O6 is {n * 50}. I type 1 in M6 and O6 equals 50. I then type 3 in M6 and O6 equals 200 {50 + 150}.
Solution:
????
Situation:
M6 - Input number
O6 - Results of M6 + O6
If M6 = 0 then O6 = 0 ; If M6 = 2 then O6 = 2
If M6 = 8 then O6 = 10 ; and so on.
I want O6 to increase each time by the amount entered in M6.
Problem:
I can not find or create a formual that will do this. I'm not sure HOW to write a macro to do this either. I have tried to create a formula and each time I enter a number in M6 the result in O6 is {n * 50}. I type 1 in M6 and O6 equals 50. I then type 3 in M6 and O6 equals 200 {50 + 150}.
Solution:
????