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

%3CLINGO-SUB%20id%3D%22lingo-sub-1274619%22%20slang%3D%22de-DE%22%3EIf-Function%3B%20No%20change%2C%20after%20the%20next%20day%2C%20because%20formula%20works%20regarding%20the%20date.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1274619%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20use%20a%20formula%2C%20to%20take%20from%20a%20chart%20(which%20changes%20each%20day)%20-%20the%20information.%20So%20that%20i%20have%20all%20the%20information%20of%20each%20day%20over%20a%20long%20time%2C%20in%20one%20Chart.%20If%20i%20put%20the%20%22if-function%22%20and%20say%20-%20%22If%20Date1%20%3D%20Date%20(changing%20chart)%22%20the%20line%20will%20of%20cours%20change%20to%200%20after%20the%20next%20day.%20Is%20there%20any%20possibility%20that%20the%20information%20will%20stay%20there%20forever%3F%3C%2FP%3E%3CP%3EIf%20I%20use%20%22If%20Date%201%3CDATE%3E%3C%2FDATE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChrisu%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1274619%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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