09-23-2020 07:04 PM
09-24-2020 12:28 AM
09-24-2020 01:21 AM - edited 09-24-2020 01:27 AMSolution
@rockyhimalayas By trial and error and some logic. No particular Excel skills needed.
First, I noted that the last two in D were half of A. Then I added B and noticed that the difference with the desired result (where B <> 0), consistently amounted to 10% of B. Hence, adding 0.9 x B did the trick.
If I had not seen the relationship at once, I would have continued with Goal Seek, I guess.
Notice though that I said that the formula could be lik that. It is very possible that there are other conditions is the real underlying formula that just don't impact the end result for this five examples given. Better check with the author of the original sheet, if possible.