Excel Expert

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

Fixed Price

Delivery by November 20, 2012

$10.00

Budget

Details

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!


About the Client

(4.71) 73 reviews

United States
Denver 04:53 AM

217 Jobs Posted
56% Hire Rate, 1 Open Job

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

$5.76/hr Avg Hourly Rate Paid
2,022 Hours

Member Since Jul 19, 2010