IF statement with 3 possible outcomes

[Guest]

HELP!!!
Cell H5 is either blank (empty), contains "N/A", or has a date.
Cell I5 will either be blank if H5 is blank, show "N/A" if H5="N/A", or take
the date in H5 and add 45 days to it.

Could someone please give me the formula that should be in I5? I've tried
=IF(H5=" "," "),IF(H5="N/A","N/A",SUM(H5+45)) but got #VALUE! regardless of
the contents of H5.

Thanks for the help!

 

[Frank Kabel]

Hi
try
=IF(H5="","",IF(H5="N/A",H5,H5+45))

 

[Guest]

Thanks Frank - You're the Best!
I guess I was on the right track. Just had too much syntax there.