HI everybody !

I try do built an IF formula , if any test fails, none of the other
ones are done.

1 ) I have this (is good in my local formula sintax) :
=IF(SUM(A1:A5)<2;IF(SUM(B1:B5)<2;IF(SUM(C1:C5)<2;I F(SUM(D1:D5)
<2;10*10;5*5))))
, but , it don't return 5*5 if , for eg. , in cell C1 the value is
6 ; it return false !

2) Is good this formula , in the sens of my logic ?(if any test fails,
none of the other
ones are done)

Thank you in advance

ytayta555;327633 Wrote:
HI everybody !

I try do built an IF formula , if any test fails, none of the other
ones are done.

1 ) I have this (is good in my local formula sintax) :
=IF(SUM(A1:A5)<2;IF(SUM(B1:B5)<2;IF(SUM(C1:C5)<2;I F(SUM(D1:D5)
<2;10*10;5*5))))
, but , it don't return 5*5 if , for eg. , in cell C1 the value is
6 ; it return false !

2) Is good this formula , in the sens of my logic ?(if any test fails,
none of the other
ones are done)

Thank you in advance

Hi,
have a look at my reply http://tinyurl.com/cpqrh4


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91554