Posted to microsoft.public.excel.misc

Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline

external usenet poster

Posts: 913

Help with nested conditional formula

On Sat, 27 Jun 2009 09:41:51 -0700 (PDT), GARY
wrote:

If M6 contains "J" or "L"
if the third character in M6 is a "-"
I want S6 to contain ""X"
else, I want S6 to contain "Y"
else, I want S6 to contain "Z".

How do I write the formula?

Try this formula in cell S6:

=IF(AND(ISERROR(FIND("J",M6)),ISERROR(FIND("L",M6) )),"Z",IF(MID(M6,3,1)="-","X","Y"))

Hope this helps / Lars-Åke

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
Can system time & date be nested in conditional formula?	Masif	Excel Worksheet Functions	1	February 25th 09 07:14 PM
Nested, Conditional, IF formula - fomatting disappears	Gayle	Excel Worksheet Functions	1	February 5th 09 02:40 AM
Nested Functions for Conditional Formatting Formula	RandyH	Excel Worksheet Functions	3	September 22nd 08 07:28 PM
nested conditional subtotals	RayB	Excel Worksheet Functions	2	April 17th 08 05:03 PM
Conditional/Nested Formula	Kuliano	Excel Worksheet Functions	4	March 18th 08 07:43 PM

All times are GMT +1. The time now is 07:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us