Hello!

I am having trouble getting my IF-function formula to always work.
This is what I'm trying to do:

=IF(DAY(A16)=17,(-(150-D16)),0)

logical test: If the date in cell A16 is the 17th of the month (where
A16 is a date).
value_if_true: then subtract the value in D16 from 150 and make it
negative
value_if_false: otherwise zero

The formula works in the first cell, but is just zero when I drag this
to the rest of the cells below it.

But get this. There is data adjacent to this formula in other cols.
When I drag down my IF function to rows beyone this adjacent data, the
formula works. The adjacent data also contains IF=functions.

Any ideas?


Thanks!
Kasmira