Remember Me?

#1
November 12th 04, 02:49 PM
 djmillis Posts: n/a
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!

#2
November 12th 04, 02:55 PM
 Frank Kabel Posts: n/a

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!

#3
November 12th 04, 03:13 PM
 djmillis Posts: n/a

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!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Paul Excel Discussion (Misc queries) 5 December 28th 04 08:11 AM Patsy Excel Worksheet Functions 0 November 11th 04 12:16 AM Patsy Excel Worksheet Functions 1 November 4th 04 03:48 PM Patsy Excel Worksheet Functions 0 November 3rd 04 03:53 PM susan hayes Excel Worksheet Functions 3 November 2nd 04 09:46 PM

All times are GMT +1. The time now is 06:32 PM.

The comments are property of their posters.