Thread: How do I combine If and AND Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default How do I combine If and AND Formula
Obfuscation is a grand thing. I remember when we wrote entire C programs on
one line. Let's keep it simple
Tyro

"Rick Rothstein (MVP - VB)" wrote in
message ...
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