I have a range on values, starting from `A1`, let's say:
Then I have a target, let's say: `43543`
Currently I am inputting values into Excel sheet and writing to cell `B1` formula `=CEILING(A1*$C$14, 1)` then dragging it down. In cell `C14` I have a factor, let's say `1.54`, then I am starting to manually adjust this factor in order to achieve `43543` as a result. In my example case I tried about 30 times until I have found that it should be `6.0588`
My question is: is there some formula that can automatically calculate this factor?
I have tried several solutions I have found, but can't get this working.
Then I have a target, let's say: `43543`
Currently I am inputting values into Excel sheet and writing to cell `B1` formula `=CEILING(A1*$C$14, 1)` then dragging it down. In cell `C14` I have a factor, let's say `1.54`, then I am starting to manually adjust this factor in order to achieve `43543` as a result. In my example case I tried about 30 times until I have found that it should be `6.0588`
My question is: is there some formula that can automatically calculate this factor?
I have tried several solutions I have found, but can't get this working.