Using the Symbol < for less than

[Guzzlr]

Hello all'
I have the following simple formula: =IF("<10",0,(MONTH(B2)))
which is giving me a "Value" error.
I'm trying to select from a range of cells 0-10 that if the range is less than 10 (for the month of October, than use the data from B2 which is formatted like this:

10/3/2016 10:18:59 AM

When I just use: =MONTH(B2) it works fine, the column returns a 10 for october. however. if there is a blank, it returns the number "1"

I like to attach a screen shot, or excel file for clarification, but I dont know how to do that...sorry

 

[Momentman]

Is your formula missing a cell reference, so you mean =IF(A1<10,0,MONTH(B2))

Wtach the quotes, if 0-10 are numbers, they dont need to be enclosed in quotes

 

[JoeMo]

Do you want this?

=IF(MONTH(B2)<10,0,MONTH(B2))

 

[Guzzlr]

Do you want this?

=IF(MONTH(B2)<10,0,MONTH(B2))

This worked,thanks
Also thanks about the comment of not needing quotes if it is a number

 

[JoeMo]

This worked,thanks
Also thanks about the comment of not needing quotes if it is a number

You are welcome - thanks for the reply.