HOW to built a IF formula , if any test fails, none of the other onesto be done ?

[ytayta555]

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;IF(SUM(D15)
<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

 

[Pecoflyer]

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;IF(SUM(D15)
<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