Thread: How do I set up a greater than but less than formula in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ikaabod[_90_] Ikaabod[_90_] is offline
external usenet poster
  
Posts: 1
Default How do I set up a greater than but less than formula in excel?

To code:

If ActiveCell 49999 And ActiveCell < 100000 Then
MsgBox "Yes"
Else
MsgBox "No"
End If

For a formula:
=IF(AND(A149999,A1<100000),"Yes","No")


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=545513

Reply With QuoteReply With Quote