Dragging with IF-Functions

[kasmira.smarzo]

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

 

[kasmira.smarzo]

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

I actually figured it out. I had a circular reference betwen my 4
different IF=Functions. Apparently this was too complicated a circle
for excel to be able to tell me exactly what it was. It just got
confused, I guess, and just defaulted to the false statement.

Kasmira