The IF function does not expect to test a range, just a single condition.
You have an array formula so it needs to be 'array entered'
Double click the cell to get into Edit mode; now commit the formula with
CTRL+SHIFT+ENTER
Excel will place the formula within curly braces { } and you will get what
you want

For more on this topic:
http://www.cpearson.com/excel/array.htm .
http://www.emailoffice.com/excel/arrays-bobumlas.html
http://office.microsoft.com/en-us/as...872901033.aspx

best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Don" wrote in message
...
=IF(DAY(B3:B30)21,N4,0) I'm trying to use this formula to check in
column B if a date of the 22nd of the month was entered (manually). If it
was, then the cell (O4 in this instance) would be equal to the contents of
cell N4, which is a numeric value. Otherwise, cell O4 would be equal to
zero
(0). The problem I'm having is that the range (B3:B30) is not being
checked
- it doesn't work. Furthermore, B4 is the only cell that allows this
formula
to work. Can't figure that one out. Do I need to rewrite the formula?
Any
help would be appreciated. Thanks!