View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default HOW to built a IF formula , if any test fails, none of the other onesto be done ?

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