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
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