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

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
__

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

Cheers
;)


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