want to check another cell

  • Thread starter Thread starter kormeroduk
  • Start date Start date
K

kormeroduk

I have three cells

(A5), (A6) & (A7).

(A5)=IF(A$1>$z1,"Check","OK") - Checks today's date if it's old. If i
is, it returns a "Check" prompt.
(A6)=IF(a2="Ended","Ended","OK")
(A7)=IF(a3="Under Review", "Under Review","OK")

I want to add to (A5) another check, a check to see if (A6) has eithe
"Ended" or "OK" if it has "Ended" then I want it to return with"ok" bu
if it has an "OK" to come back with the original result IE "Check" o
"ok".

Can you help?

Kormeroduk..
 
Hi
try the following in A5:
=IF(A6="Ended","OK",IF(A6="OK",IF(A$1>$z1,"Check","OK"),""))
 
Back
Top