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