1. I have a spreadsheet that is tracking orders and a column gives the status: Ordered, ordering, received, receiving, denied, rejected, etc..... I need an "if" formula in column "M" that is true if column "E" is ordered, ordering, receiving, or received.
Assuming data starts in row 2
=IF(OR(E2={"ordered", "ordering", "receiving", "received"}), "true", "false")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That did the trick, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks