Not my formula which was ....

=IF($A2=0,($C1/$B1)*$B2,$A2*$B2)

worked for a merged cell of 5

Right... I see, as long as the C above is resolved first, it... got it.

I was copying-down the PAIR of C1/C2, you meant just copy-down C2.


---------------------------------------------------------
Works splendidly! Clever inductive logic type of formula. Thank you
---------------------------------------------------------

I wasn't thinking that way (and, well, didn't know about IF). My looking at
the (largely useless, no-index, requires internet connection) help was
showing me things like VLOOKUP so I was imagining something involving a
search.