Posted to microsoft.public.excel.worksheet.functions

Max

external usenet poster

Posts: 390

If function with 3 different outcomes

How to use the IF function to get 3 different outcomes. If E17<C17 then
"Below Range", If E17D17 "Above Range" IF E17 is between between C17 AND D17
then In Range.. How do i do this?

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 formula with 3 possible outcomes	Aaron Hodson \(Coversure\)	Excel Worksheet Functions	8	November 8th 07 04:52 PM
#N/A outcomes in formulas	Caroline	Excel Discussion (Misc queries)	2	August 29th 07 03:33 PM
formula outcomes	biker man	Excel Discussion (Misc queries)	2	August 29th 07 01:07 PM
256 possible outcomes	MarkN	Excel Discussion (Misc queries)	9	June 28th 06 08:33 AM
best and worst outcomes	xela1986	Excel Worksheet Functions	1	April 24th 06 11:27 PM

All times are GMT +1. The time now is 02:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us