IF function
TY David.
I have both problems and still need to find asolution for my original
question but the thing is that the nesting if(and(this1,this2;true;false)) or
if(this;(and(true,true));false) doesn't seem to work. I always get a message
regarding the missuse of comma.
--
JuanB
"David Biddulph" wrote:
=IF(AND(this1,this2);true;false)
.... but that didn't seem to be what you were asking for the first time,
which was the question which joeu2004 answered for you; at that stage you
had one condition and two true responses, but now you have two conditions to
be ANDed and one true response?
--
David Biddulph
"Juan Bta." wrote in message
...
My Excel 2003 doesn't accept (,) I have to use (;) but it doesn't work
anyway.
Let's put it in other words. If the condions are two instead of just one,
say:
=if(this and this;true;false) how would you do it??
"Muhammed Rafeek M" wrote:
=if(c24="W",And(c20=20, b20=c20+1),whatever)
please do rate
"Juan Bta." wrote:
My problem is, if condition is met I need two true responses.
=if(c24="W";c20=20 "and" b20=c20+1;whatever)
Any help??
--
JuanB
|