How to not read a cell with a formula as a value

[williamthomp]

I have a "IF" formula that doesnt seem to be working due to the fact that it is seeing a cell with a formula in it as a value. Is there a way to have the if statement work thru it iterations
only if it has an actual value in it and not just a formula.

thanks in advance for any help

Bill

=IF(AO21>0,"Delivered",IF(AN21>0,"Out for Delivery",IF(AF21>0,"Arrived",IF(X21="","On Ground","Lifted")))))

PS all the columns are actually formatted date columns if that helps

[Spencer101]

Could you post an example workbook with representative but dummy data?

[Cutter]

Instead of IF(AO21>0, try IF(AO21<>"", and change the others similarly.

[williamthomp]

Hey Spencer, The sheet is too complex to send with dummy data. Cutter..I tryid your example but it stopped at the first example of a non blank cell and I need this to go to the last true statement of if that cell is not blank then go with that answer. All the cells have vlookup formulas in them so that is why I am trying this method of using an if statement that sees only values in cells and not formulas

Here is your example with the revised formula

=IF(AQ184<>"","Delivered",IF(AP184<>"","Out for Delivery",IF(AH184<>"","Arrived",IF(Z184="","On Ground","Lifted"))))

[Spencer101]

What do you mean by "it stopped at the first example of a non blank cell" ?

[Cutter]

Do you have something in one of those tested cells that looks like it's blank but it isn't? Like a space, or something formatted white (or whatever fill colour is)?

[williamthomp]

Thanks Everyone for being my sounding boards..Turns out I had the sequence wrong of what to check first plus the formatting was throwing it off so I had to do a work around of using new columns to place create a "is equal to scenario" that allowed me to change the formatting

thanks,
Bill