Excel Expert

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Accounting Posted 3 years ago

Fixed Price

Delivery by November 20, 2012




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.


About the Client

(4.71) 75 reviews

United States
Denver 02:46 PM

217 Jobs Posted
56% Hire Rate, 1 Open Job

Over $10,000 Total Spent
134 Hires, 0 Active

$5.77/hr Avg Hourly Rate Paid
2,027 Hours

Member Since Jul 19, 2010