I would like A3 to display A2 if it has a quantity and A1 if it does not,sometimes neither A1 or A2 will have quantities.
=if(a2<>"", a2, if(a1<>"", a1, ""))