IF Statement Formula

[cjbrady97]

Hi,

I'm trying to figure out a formula that has a number of parts.

Let's say that we have columns A, B and C.


Column A will contain either a date, or be a blank cell. B will contain "Accepted", or a blank cell.


I want Column C to return either "Open", "Approved", or be blank, depending on Columns A and B.


If A=Blank, B="Accepted", C should equal "Open"
If A="Date", B="Accepted", C should equal "Approved"
If B=Blank, C should always equal Blank.


Thanks in advance.

 

[njimack]

=IF(B2="","",IF(A2="","Open","Approved"))