I am trying to create a format where Column 1 will copy the text from column 2, unless column 2 is blank, then it will copy the text from column 3 instead.
I am creating an order sheet. Some items are ordered by each, others by case/box/pack/etc.
In my above inquiry:
Column 1 – would be my label for what I should order by (each, box, case, etc)
Column 2 – would be the inventory tracker that I have created and column 2 is where I have indicated if we can order by box/pack/etc
Column 3 – the second part of the inventory tracker. This has individual “each” items. Now, some of the items in column 2 will also have inventory in this column, but when we order those items that have a label of box/case/pack/etc in column 2 – we do not order by each – we order by box/case/pack/etc.
In reality, I have the actual numbers listed in the column next to the label, but I have those formulas all figured out, just trying to make this easier as well – in the long run
—–
R.Fulenwider
For this, just use an IF function. See https://macmost.com/learn-how-to-use-the-if-function-in-numbers.html
So something like this in A2:
IF(ISBLANK(B2),C2,B2)
The condition is to check if B2 is blank. If it is, get the value of C2. If it isn't blank, then get the value of B2.