IF statement with 3 possible outcomes
 

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!

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

--
Regards
Frank Kabel
Frankfurt, Germany

"djmillis" schrieb im Newsbeitrag
...
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!

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"djmillis" schrieb im Newsbeitrag
...
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!