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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement with Average Function results in #Value!	Paul	Excel Discussion (Misc queries)	5	December 28th 04 08:11 AM
Duplicate fields does not match up! If statement	Patsy	Excel Worksheet Functions	0	November 11th 04 12:16 AM
If statement needed	Patsy	Excel Worksheet Functions	1	November 4th 04 03:48 PM
Duplicate fields does not match up! If statement	Patsy	Excel Worksheet Functions	0	November 3rd 04 03:53 PM
IF Statement difficulty	susan hayes	Excel Worksheet Functions	3	November 2nd 04 09:46 PM

All times are GMT +1. The time now is 12:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us