|
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 |
HOW to built a IF formula , if any test fails, none of the other onesto be done ?
ytayta555;327633 Wrote: 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 Hi, have a look at my reply http://tinyurl.com/cpqrh4 -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=91554 |
| All times are GMT +1. The time now is 09:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com