If

Question

=SE(G24&gt;50;J24+1;J24+2)this formula should return me has a number: if G24 bigger then 50, H24 should be year I24+1, if G24 less then 50, should be year I24+2&nbsp;&nbsp;

oliverscheurich · Answer

Ana_Guerra&nbsp;=SE(G24&gt;50;ANO(I24)+1;SE(G24&lt;50;ANO(I24)+2;""))You can try this formula.

ana_guerra · Answer

the samenote thatcell E has a formula&nbsp;=ANO(D24)-ANO(E24)&nbsp;&nbsp;&nbsp;OliverScheurich&nbsp;

oliverscheurich · Answer

Ana_Guerra&nbsp;=ANO(D24)-ANO(E24)If this formula is in column E it should create a circular reference. Unfortunately i'm now unsure what you want to do. Can you attach a sample file without sensitive data?&nbsp;

ana_guerra · Answer

OliverScheurich&nbsp;&nbsp;not able to attache file but try to send you all cells formsF15 "=ANO(D15)-ANO(E15)"G15 "=SE(F15&gt;50;ANO(H15)+1;SE(F15&lt;50;ANO(H15)+2;""))"&nbsp;&nbsp;

oliverscheurich · Answer

Ana_Guerra&nbsp;It seems that the formulas work as expected. You only have to change the format of the cells.&nbsp;In my example in column H the format is date (Datum in german)&nbsp;And in column G the format is standard (Standard in german)

Forum Discussion

If

6 Replies