Posted to microsoft.public.excel.worksheet.functions

Rianne

external usenet poster

Posts: 7

Too Many If's

I'm trying to write a formula that will locate an asterisk (*) in a large
range of data, and if it is found, put a statement like "Hey, I found an
asterisk!" in one cell. I can't seem to get my head around the formula, asn
I've only been able to replicate what I want by using multiple IF statements.
I have over 200 cells that could have the asterisk in it. Please help, it
would be greatly appreciated.

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's	karensa	Excel Worksheet Functions	4	December 27th 06 10:05 PM
Combining IF's	Carl	Excel Worksheet Functions	1	November 27th 06 05:01 AM
How many 'if's'?	Lynneth	Excel Discussion (Misc queries)	1	May 4th 06 03:59 PM
to many 'IF's'??	boufant	Excel Worksheet Functions	4	July 2nd 05 10:58 AM
How many if's?	Christopher Anderson	Excel Discussion (Misc queries)	4	January 5th 05 03:16 PM

All times are GMT +1. The time now is 12:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us