On Sat, 4 Mar 2006 07:42:02 -0600, Cobbcouk
wrote:


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


=IF(AND(ISTEXT(E102),SUM(G102:AJ102)=1),1,0)

HTH
Richard Buttrey
__