Posted to microsoft.public.excel.worksheet.functions

kevan

external usenet poster

Posts: 4

combining IF OR Functions

I am trying to combine the following if functions with an or funtion which
will provide mw with the answer 6,10,14,21 or 25.
=IF($AG$2="3-6","6", "Not OK")
=IF($AG$3="7-10","10", "Not OK")
=IF($AG$4="11-14","14", "Not OK")
=IF($AG$5="18-21","21", "Not OK")
=IF($AG$6="22-25","25", "Not OK")

My attempts so far are futile. Can anyone help?

Thanks

--
kevan

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
Combining Functions	MikeM	Excel Discussion (Misc queries)	5	October 16th 08 02:31 PM
combining IF, AND, and OR Functions	Hillary: needing some help[_2_]	Excel Worksheet Functions	5	October 9th 08 04:37 PM
Combining Functions	MikeM	Excel Discussion (Misc queries)	3	September 30th 08 04:52 PM
Combining IF and OR Functions	ConfusedNHouston	Excel Discussion (Misc queries)	2	October 4th 06 12:38 AM
Combining IF OR and AND functions	andyp161	Excel Worksheet Functions	3	April 20th 06 06:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us