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$1<shifts!$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