Forum Discussion

Jamesb1982

Copper Contributor

Jul 05, 2023

Excel formula Help

Hey Guys. I'm using a formula of =E445 + IF((G445 = "Yes "), 28, 14) to calcuate a date. However, when either E445 or G445 are blank its giving a value of 14/01/1900. Any idea how if the ...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jul 05, 2023

Jamesb1982

As variant

=IF( OR(E445="", G445=""), "", E445 + 14*( 1+ (G445 = "Yes ") ) )