Thanks for replying, Pecoflyer. I phrased the scenario in a generic fashion for simplicity and brevity. In the real-world scenario (which is similar, but not identical to the one I portrayed), it wouldn't be feasible to put anything into Column B until we have received data back.
Quote:
Originally Posted by Pecoflyer
Hi
it seems that the final cost column should contain the final cost. So, instead of an empty cell, B2 for instance should contain the same as A2 as long as you have no lower price. Savings would then correctly be 0
|