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

[ytayta555]

HI everybody !

I try to built a IF formula , if any test fails, none of the other
ones to be done ;

1) I have this formula :
=IF(SUM(A1:A5)<2;IF(SUM(B1:B5)<2;IF(SUM(C1:C5)<2;SUM(D15);5*5)))
but , for eg. it return FALSE , if in cell C1 the value is 3 , it
don't return
the value of 5*5 , how I expected .

2) Is this formula good , in the sense of my logic ? ...( if any test
fails, none
of the other ones to be done ) ?

Many thanks in advance

 

[Pecoflyer]

Hi,
I don't really understand what you are trying to achieve.
What is 5*5? 25? a text string "5*5"?
But assuming that if any of the tests fails the value the cell gets is
25 you can start as follows
=if(or(sum(a1:a5)<2;sum(b1:b5)<2),25,anothervalue)
What happens when all tests succeed?

HI everybody !

I try to built a IF formula , if any test fails, none of the other
ones to be done ;

1) I have this formula :
=IF(SUM(A1:A5)<2;IF(SUM(B1:B5)<2;IF(SUM(C1:C5)<2;SUM(D15);5*5)))
but , for eg. it return FALSE , if in cell C1 the value is 3 , it
don't return
the value of 5*5 , how I expected .

2) Is this formula good , in the sense of my logic ? ...( if any test
fails, none
of the other ones to be done ) ?

Many thanks in advance

--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster