I am trying to compose a formula that will look at a series of cells. If the
first is blank (or zero), then it goes to the next. If the next is blank, it
goes to the third. So, if A3 has a value, use it, if not, go to A2. If A2
has a value and not A3, use it and if not, go to and use whatever is in cell
A1.

Someone please help. Thanks to all!!!