megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 140
- Office Version
- 365
- Platform
- Windows
This seems like an exceedingly simple problem but I'm having trouble applying my Google results to my situation.
I have a table full of sales data, with Invoice Numbers in Column C. In a formula I've got way over in Column X, I just want to say if Column C contains "A", "B", "C" or "D" is true, run one formula and if it it's false, run a different one. I've already got those formulas and don't need help with that, just how to write the logical test.
A lot of what I found on Google was checking a range for a value in a different cell but I don't have it set up that way and don't really want to.
I have a table full of sales data, with Invoice Numbers in Column C. In a formula I've got way over in Column X, I just want to say if Column C contains "A", "B", "C" or "D" is true, run one formula and if it it's false, run a different one. I've already got those formulas and don't need help with that, just how to write the logical test.
A lot of what I found on Google was checking a range for a value in a different cell but I don't have it set up that way and don't really want to.