Please help!

C

Cobbcouk

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:confused:

Regards
Gaz
 
C

Cobbcouk

Many Thanks Richard I was having a particularly bad day. The forums are
great I so glad I have found them:)

Cheers
;)
 
Top