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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.