Hi

I have an IF statement which shows the expected answer in the formula wizard, but returns "#VALUE!" in the cell, depending on location. The formula displays correctly if it's in the same column as one of the queried cells, but doesn't if placed anywhere else.
I have checked the cell formatting and this is the same throughout the sheet.

The spreadsheet has been written in Excel 2000.

For info, the problem formula is:
=IF(N4:S4="overdue","Overdue","ok")

Where the queried cells (N4:S4) contain variations of the following:
=IF(AG4<N2+22,"overdue",AG4-21)

AG4 is a specified date, and N2 is today's date.

Many thanks for your time.