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

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;S UM(D1:D5);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

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

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?

ytayta555;327695 Wrote:
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;S UM(D1:D5);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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91573