Wenn-Function; No change, after the next day, because formula works regarding the date.

Copper Contributor

Hello,

 

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".

 

Any ideas?

 

Many thanks.

 

Chrisu

0 Replies