Help with IF statement within Table

[cubs610]

Hello All,

I thought this would be easy, yet I'm missing something. The attached file uses a table and my understanding is the Excel table formula structure are a little different. What I'd like to accomplish is, if either cells G2 or H2 are blank then leave cell I2 blank.

I know there is something wrong with the formula just not sure. Love to hear your suggestions.

Thanks!
-Dave

 

[Chihiro]

Formula syntax is same for table as anywhere else in Excel.

Only difference is how range/cell is referenced.

Have a read of link below.
https://support.office.com/en-us/ar...l-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

Something like below for your case.
=IF(OR([@[Current Due Date]]="",[@[Completion Date]]=""),"",[@[Completion Date]]-[@[Current Due Date]])

 

[cubs610]

@Chihiro -- Thanks so much and to answer your question, no I have not read the article. I'll give it a glance when I have a moment. Thanks! -dave