This is the written out version of what I need converted to Excel speak. Don't think it possible in one formula, so may be looking at a series of steps.
If B2 > 0 enter "In stock" in C2. If B2 = 0 and A2 appears in column G, enter "Discontinued" in C2. If B2 = 0 and A2 appears in column H, enter "Preorder" in C2. If B2 = 0 and A2 does not appear in either columns G or H, enter "Out of stock" in C2.
Can anyone help me make this happen?
Thanks in advance for any assistance!
Denise
Bookmarks