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!
|