Closed - This job posting has been filled and work has been completed.
We need an Excel expert to write a formula.
There is a spreadsheet with three columns.
Column A contains multiple words, Column B has a value less than 1 and Column C has a value greater than 500.
The formula should say if Column A contains any of the following words (John or Jane or Joe) AND the Column B is less than .65 AND Column C is greater than 1,000 then the answer is 'ok' and if not the answer is 'not ok'.
I'm attaching a spreadsheet with some sample data for you to try.
Please let me know if you have any questions.