About Us

proverbs

Oh thank you John, yes it does. One for the records!

Phill (alias proverbs)
with apology to administrator for not yet understand the 'snip'

Quote:

Originally Posted by John James

Drop the double quotes from your formula

"1" is text whereas 1 is a number

Does this help?

proverbs Wrote:
The formula
(referenced) is =IF(AND(I$1=shifts!$J3,I$1shifts!$L3),"1","0"). This
places either the value ‘0’ or the value’1’ in a referenced cells.

This works satisfactorily in a test sheet where ‘0’ and ‘1’ are
entered
manually but not when these values are the results of the IF/AND
formula.

--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533978

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy/Paste how to avoid the copy of formula cells w/o calc values	Dennis	Excel Discussion (Misc queries)	10	March 2nd 06 10:47 PM
CSE formula results	sa02000	Excel Discussion (Misc queries)	4	February 7th 06 03:52 PM
Conditional formatting...cont. from 9/25	Guenzak	Excel Discussion (Misc queries)	4	September 26th 05 10:55 PM
quick way to copy-paste a formula linked to cells in another file	iniakupake	Excel Worksheet Functions	2	September 26th 05 03:56 AM
Cells displays formula, not results	synaptic5150	Excel Worksheet Functions	1	January 19th 05 09:56 PM

Menu

About Us