Thread: is there an AND logical ?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default is there an AND logical ?
Try this:

=--AND(A1=1,B1=C1)

--
Biff
Microsoft Excel MVP


"0nanman" wrote in message
...
i want to check multiple cells with something like:

IF CellA=1 AND IF CellB=CellC,1


Reply With QuoteReply With Quote