Posted to microsoft.public.excel.worksheet.functions

Archana

external usenet poster

Posts: 5

Long Logical function

I have a tracking sheet where I want to enter a formula to enter in cell
"done" if a range of cells from A3:A54 all have a value "done" or "NA" else
keep blank.
How do I do it?
The formula is turning out t be too long and cannot be entered.

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
Logical function	Lavanya	Excel Discussion (Misc queries)	1	January 25th 07 06:20 AM
should it be if() or another logical function?	Gina	Excel Worksheet Functions	2	November 10th 06 05:59 PM
logical function	[email protected]	Excel Worksheet Functions	4	July 27th 06 04:43 AM
Logical Function	brandyda	Excel Worksheet Functions	2	June 2nd 05 05:19 PM
Logical AND function	John Pinback	Excel Worksheet Functions	5	May 3rd 05 09:52 PM

All times are GMT +1. The time now is 07:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us