Dragging with IF-Functions
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 |
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 |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com