Thread: Using If function for Great and less than function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muskrat24 Muskrat24 is offline
external usenet poster
  
Posts: 21
Default Using If function for Great and less than function
I copied and pasted that equation in and it didnt work


"Jacob Skaria" wrote:

In C1
=IF(AND(A13000,A1<4000),"X","")

If this post helps click Yes
---------------
Jacob Skaria


"Muskrat24" wrote:

I want to use a IF fuction for greater than or less than
IF A1 is greater than 3000, but less than 4000, than I want C1 to be a "X"

how do i do this

Thanks
Reply With QuoteReply With Quote