IFfunction

Posts: n/a

Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE

I would like to write an IF formula with the condition:
IF two or more values in a range of six values are <3 then state "true"

I only know how to conditon "if one number in a range is <3 then true. How
to do it when you want to know if there are at least two numbers that show <3?

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
Match function...random search?	Les	Excel Worksheet Functions	10	July 28th 05 11:54 AM
How do I copy cell values (derived from formula), not references?	Matt in a spot of bother	Excel Worksheet Functions	4	July 28th 05 08:09 AM
SUMIF where values to be summed are formula	Zakynthos	Excel Worksheet Functions	10	July 27th 05 04:05 PM
specify range name in formula with concatenated string	Lori H	Excel Worksheet Functions	2	July 19th 05 03:07 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us