Hi,
Im not new to excel but I fear that I can't see the forest for the
trees and I need some help.

I'm trying to write a formula that will return a value of "1" if there
is any text in cell "e102", and the sum of cells (G102:AJ102)=1. The
formula also needs to return a value of "0" if either criteria is not
met.

Please help
Im having a bad day

Regards
Gaz


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=518978