Posted to microsoft.public.excel.programming

gcotterl[_2_] gcotterl[_2_] is offline

external usenet poster

Posts: 83

Help needed nested conditional formula

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?

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
Help with nested conditional formula	Lars-Åke Aspelin[_2_]	Excel Discussion (Misc queries)	0	June 27th 09 07:07 PM
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
Conditional/Nested Formula	Kuliano	Excel Worksheet Functions	4	March 18th 08 07:43 PM

All times are GMT +1. The time now is 10:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us