Thread: Use of "AND"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Use of "AND"
Hi,
when you want to meet two conditions for example
A1= 2
A2= 3

if the conditions above are true you want to result be "OK" otherwise "WRONG"

=if(and(A1=2,A2=3),"OK","WRONG")

"Wally" wrote:

How do i use "AND" in an if statement on Excel worksheet?
Reply With QuoteReply With Quote