Posted to microsoft.public.excel.misc

Dave Shultz Dave Shultz is offline

external usenet poster

Posts: 14

nested If

Perfect. Worked like a charm. You rock!

"Elkar" wrote:

Try this:

=IF(I5="","",IF(J5="","In Progress","Closed"))

HTH
Elkar

"Dave Shultz" wrote:

Heres my dilemma:
If cell I5 is null and J5 is null, I want L5 to be null
If I5 is not null and J5 is null, I want L5 to return €œIn Progress€
If I5 is not null and J5 is not null, I want L5 to return €œClosed€
Any suggestions???

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Nested IF	Tony	Excel Worksheet Functions	2	June 21st 08 07:18 PM
Nested If	Rhonda	Excel Worksheet Functions	3	April 2nd 08 05:23 PM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
using nested OR	stef	Excel Worksheet Functions	18	November 3rd 06 09:35 PM
nested if	Ash	Excel Worksheet Functions	1	May 31st 06 09:29 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us