Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW to built a IF formula , if any test fails, none of the other onesto be done ? | Excel Worksheet Functions | |||
Excel formula fails to update | Excel Discussion (Misc queries) | |||
Formula fails in text formatted cell | Excel Worksheet Functions | |||
How to use built-in Excel functions in PivotTable formula? | Excel Worksheet Functions | |||
VBA Formula Fails to Execute | Setting up and Configuration of Excel |