Blank Cells

[Lando_Ritchie]

Hello! If anyone could help, I'd really appreciate it...

So, I need a formula that will ignore blank cells. The formula is in F4. I need F4 to show a date, preferably the one in I4, if the date in I4 is blank, then I need it to return the date in E4+14, but if E4 is blank, I need F4 to be blank.
I've currently got
=IF(I4="",(E4+14), I4)
When I've tried to add in IFs for a blank E4, it says I have too many arguments, or I get a VALUE error
e.g. =IF(I4="", (E4+14), IF(E4="","",(E4+14)) gives me a VALUE error,
Any help or advice would be great!

[#2]

@Lando_Ritchie 

That could be

=E4+14*(I4<>"")*(E4<>"")

[#3]

@Sergei Baklan 

It's given me 00/01/1900, but seems like I'm getting closer, maybe!

[#4 · Accepted solution]

@Lando_Ritchie 

I believe you need the following formula:

=IF(E4="","",IF(I4="",E4+14,I4))

Similar to @Sergei Baklan 's solution, but closer to the way you tried to write the formula.

[#5]

It works! Thank you so much!!

@Riny_van_Eekelen