Thread: IF function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default IF function

=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