i want to use a formula, to take from a chart (which changes each day) - the information. So that i have all the information of each day over a long time, in one Chart. If i put the "Wenn-Function" and say - "Wenn Date1 = Date (changing chart)" the line will of cours change to 0 after the next day. Is there any possibility, that the information will stay there forever?
If I use "If Date 1<Date(changing chart), take information of line "Date1"; and put after this the formula to get the information, I got an error-message. "Zirkelbezug".