Thread: How do I combine If and AND Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_50_] Rick Rothstein \(MVP - VB\)[_50_] is offline
external usenet poster
  
Posts: 1
Default How do I combine If and AND Formula
Use the AND function

=IF(AND(A1=12,A1<24),"X","") or perhaps you meant
=IF(AND(A1=12,A1<=24),"X","")

If she meant the latter one, it's possible to have a formula without even
using the AND function...

=IF(ABS(A1-18)<=6,"X","")

Rick

Reply With QuoteReply With Quote