Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to determine the value? | Excel Worksheet Functions | |||
How to determine the value? | Excel Worksheet Functions | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) |