IF Function -- Based on two cells

[cwhaley2]

Hello all, very grateful for any assistance in helping me complete a formula.

I have a 3 cells. Cell A1 contains the date for logging an issue, Cell B1 contains the date an issue was completed and cell C1 contains the status (either pending or resolved) based on which cells have dates in. If there is only the date of an issue being logged it returns "Pending Resolution" and if there is a date in both then it should return "Resolved". If no dates are entered it needs to be blank.

The formula I've created so far is:

=IF(A1<>"",IF(ISNUMBER(A1:B1),"Resolved","Pending Resolution"),"")

This works in so far as it will show "Pending Resolution" if a date is entered into A1, but if I enter a date into B1 it will still show "Pending Resolution" and not "Resolved" as expected.

Where am I going wrong with this? I feel it could benefit from an AND function but I don't know how to use this.

 

[AlanY]

try

=if(isnumber(B1),"Resolved",if(isnumber(A1),"Pending Resolution",""))

 

[Fluff]

Hi & welcome to MrExcel
How about
=IF(A1="","",IF(B1="","Pending Resolution","Resolved"))