Thread: AARON
View Single Post
  #4  
Old December 18th, 2003, 08:39 PM
Norman Harker
external usenet poster
 
Posts: n/a
Default AARON

Hi!

The functions AND and OR return TRUE or FALSE. That is the requirement
of the condition argument in the IF function. So:

=IF(AND(C2=C3,B2=B3),"Two Pairs","Not Two Pairs")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
wrote in message
...
can AND be put into an IF statment to make two arguments.

Like If C2=C3 AND B2=B3 ,B3=0,...

any suggestions