E
Eric
Does anyone have any suggestions on how to determine the value?
There is a value 144 in cell A1,
There is a value 10 in cell B1,
I input 140 in cell C1, as 144 >= 140 >= 134 (144-10), then it return 144 in
cell D1.
I input 150 in cell C1, as 150 >= 144, then it return 154 (144+10) in cell D1.
I input 160 in cell C1, as 160 >= 144, then it return 164 (144+10*2) in cell
D1.
I input 170 in cell C1, as 170 >= 144, then it return 174 (144+10*3) in cell
D1.
I input 130 in cell C1, as 134 (144-10) >= 130, then it return 134 in cell D1.
I input 120 in cell C1, as 124 (144-10*2) >= 120, then it return 124 in cell
D1.
I input 110 in cell C1, as 114 (144-10*3) >= 110, then it return 114 in cell
D1.
I input 100 in cell C1, as 104 (144-10*4) >= 100, then it return 104 in cell
D1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
There is a value 144 in cell A1,
There is a value 10 in cell B1,
I input 140 in cell C1, as 144 >= 140 >= 134 (144-10), then it return 144 in
cell D1.
I input 150 in cell C1, as 150 >= 144, then it return 154 (144+10) in cell D1.
I input 160 in cell C1, as 160 >= 144, then it return 164 (144+10*2) in cell
D1.
I input 170 in cell C1, as 170 >= 144, then it return 174 (144+10*3) in cell
D1.
I input 130 in cell C1, as 134 (144-10) >= 130, then it return 134 in cell D1.
I input 120 in cell C1, as 124 (144-10*2) >= 120, then it return 124 in cell
D1.
I input 110 in cell C1, as 114 (144-10*3) >= 110, then it return 114 in cell
D1.
I input 100 in cell C1, as 104 (144-10*4) >= 100, then it return 104 in cell
D1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric