# Excel formula

IN PROGRESS
Bids
57
Avg Bid (USD)
\$84
Project Budget (USD)
\$30 - \$250

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

Skills required:
Excel
Project ID: 4498211
Report Project
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

\$ 94
in 3 days
\$ 35
in 3 days
\$ 50
in 1 days
\$ 166
in 4 days
\$ 35
in 1 days
\$ 60
in 3 days
\$ 35
in 1 days
\$ 147
in 4 days
\$ 50
in 1 days
\$ 55
in 1 days