Excel Expert

Closed - This job posting has been filled and work has been completed.

Job Description

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.

Thanks!

Open Attachment