K
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 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