Completed

Excel formula

This project was successfully completed by vaibhav585 for $30 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
57
Project Description

Buyer needs a formula that evaluates a number of columns in the row to determine what it's value should be. The rules of the formula are listed below and should be evaluated in this order:

1) If cell P has a valid date value make cell A say “Lucid ” + date value of cell P
2) If cell P does not have a valid date value and cell O does have valid date value then make cell A say “HN Level2 “ + date value of cell O
3) If cell P and O do not have valid dates and cell N does have valid date value then make cell A say “HN Level1 “ + date value of cell N
4) If cell P, O, and N do not have valid dates and M does have valid date value then make cell A say “Trans Received “ + date value of cell M
5) If cell P, O, N, and M do not have valid dates L does have valid date then make cell A say “Trans Requested “ + date value of cell L
6) If cell P, O, N, M and L do not have valid dates K does have valid date then make cell A say Lucidance Requested “ + date value of cell K
7) If cell G is <= seven days from today and cell P does not have a valid date make row red and make cell A say "Danger Close: " + # of days from today
8) Add columns(R through W) on the row that tell the number of days between cells K & L(R), L & M(S), M & N(T), N & O(U), O & P(V), and P & Q(W); if one of the cells do not contain a valid date then leave the cell blank

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online