software

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 quot;1quot; if there
is any text in cell quot;e102quot;, and the sum of cells (G102:AJ102)=1. The
formula also needs to return a value of quot;0quot; if either criteria is not
met.

Please help
Im having a bad day

Regards
Gaz--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: www.excelforum.com/member.php...oamp;userid=32143
View this thread: www.excelforum.com/showthread...hreadid=518978On Sat, 4 Mar 2006 07:42:02 -0600, Cobbcouk
gt; wrote:

gt;
gt;Hi,
gt;Im not new to excel but I fear that I can't see the forest for the
gt;trees and I need some help.
gt;
gt;I'm trying to write a formula that will return a value of quot;1quot; if there
gt;is any text in cell quot;e102quot;, and the sum of cells (G102:AJ102)=1. The
gt;formula also needs to return a value of quot;0quot; if either criteria is not
gt;met.
gt;
gt;Please help
gt;Im having a bad day
gt;
gt;Regards
gt;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: www.excelforum.com/member.php...oamp;userid=32143
View this thread: www.excelforum.com/showthread...hreadid=518978