View Single Post
  #1   Report Post  
djmillis
 
Posts: n/a
Default 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!