I have two columns. A is full of numbers, and B has some numbers and some blank cells.
I want a formula for C1 that says 'If B1 is blank, use the number in A1. If B1 isn't blank, use the number in B1'.
So, for example, the end result would look like this