Quote Originally Posted by blueswan View Post
It doesn't work based on the requirements I've given.
That doesnt exactly help too much Perhaps your requirements where not explained to clearly?

try this, copied down...
=IF(F4=1-D4+E4,TRUE,FALSE)

or justthis...
=F4=1-D4+E4