Posted to microsoft.public.excel.programming

external usenet poster

Posts: 12

Simplifying an If(OR(…)) statement

Is there a way to do the following without using if(OR(…, …, …, ….,
…)) for each of 100 cells? I have a column of 100 cells each
containing a number from 1 through 10. If the number 7 is greater
than any of the 100 cell’s I want it to say “yes”, otherwise “no”..

Example: if(or(7A1, 7A2, 7A3, …, 7A100), “yes”, “no”)

Thanks

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
Simplifying IF Statement	Ray	Excel Programming	3	October 13th 09 05:34 AM
Need help simplifying VBA code	jlclyde	Excel Discussion (Misc queries)	4	September 4th 08 04:21 PM
Simplifying VBA code	Michael M	Excel Worksheet Functions	8	January 24th 07 02:17 PM
Simplifying a formula	MartinW	Excel Worksheet Functions	3	June 19th 06 11:50 AM
Simplifying VBA code	Steve[_71_]	Excel Programming	7	November 2nd 04 07:44 PM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us