Dragging with IF-Functions
On Jun 21, 2:41 pm, "kasmira.smarzo" wrote:
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
|