Hi. I have a formula that relies on a series of monthly updates all being populated before it will produce an outcome. What this means is that even if I have 2 out of 3 of the values that I need, the formula will not produce an answer until the 3rd value is available. I would like to re-construct the formula so that if there are 2 out of 3 of the values available (any 2 of them) then the remaining cell gets populated with the 'last value' that it was (ie from the row above), so that the final formula can produce a number.
So in this instance, if I have any 2 of AI370 / G370 / F370, then I would like the formula to act use the last value of the last cell. I.e. use AI369 instead of AI370 - if AI370 was the only value that was missing.