=if(a2<>"", a2, if(a1<>"", a1, ""))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, ""))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.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks