IF Formula Help

[Karl]

Hello - some formula help please!

I have attached a file with a small snippet of my columns, what I am trying to do is;

- Create a formula in column E
- If there is a date in any of the cells A2:A4 OR G2:G4 then I want it to return "Hold"
- If there isn't a date in any of the cells I need to know how many days have passed between "Phase 3 outcome" and "NOPO issue date".

I can currently get this to work one way with; =IF(ISNUMBER(AC2),"Hold",(TODAY()-AE2)) but can't work out how to add the "G" cell.

Any help would be greatly appreciated.

 

[Somendra Misra]

Hi Karl,

Can you try this in E2 and copy down:

=IF(OR(ISNUMBER(G2),ISNUMBER(A2)),"Hold",C2-B2)

Regards,

 

[Karl]

Wow thank you for the speedy response - you really are an Excel Ninja!

A quick follow up question (My data set has evolved already), my formula now has a daily countdown;

=IF(OR(ISNUMBER(AC4),ISNUMBER(AJ4)),"Hold",(AF4-TODAY()))

As I want the same column to automatically update as I input new data I have dragged the formula down - I now get "-41747" when no data is in A:2 to D:3 - is there a way to get rid of this?

 

[Somendra Misra]

@Karl

So if you want to show blanks when there is no data in cell AF4, try a formula of structure something like this:

=IF(OR(ISNUMBER(G2),ISNUMBER(A2)),"Hold",IF(C2="","",C2-TODAY()))

Regards,