# Excel formula

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: Excel