Posted to microsoft.public.excel.newusers

gimp

Posts: n/a

another complex =IF question

i was given the formula to use in cell A1 if cell b1 = x to make A1
either be blank if it said something other than x, or if it said x it
would generate an (*). now is there a formula that can be used in the
same senario if B1 had a series of possible values to generate a (*) in
cell A1?

thanks again

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
Anybody Help with previous question	Anthony	Excel Discussion (Misc queries)	1	July 26th 05 01:26 PM
Complex query question	Stacy	Excel Worksheet Functions	0	June 30th 05 09:50 PM
Hints And Tips For New Posters In The Excel Newsgroups	Gary Brown	Excel Worksheet Functions	0	April 15th 05 05:47 PM
complex count question	JBoulton	Excel Worksheet Functions	13	March 24th 05 02:57 AM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question	Barb Reinhardt	Charts and Charting in Excel	3	December 8th 04 01:48 AM

All times are GMT +1. The time now is 05:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us