Forum Discussion
=SE(G24>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
=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?
not able to attache file but try to send you all cells forms
F15 "=ANO(D15)-ANO(E15)"
G15 "=SE(F15>50;ANO(H15)+1;SE(F15<50;ANO(H15)+2;""))"
It seems that the formulas work as expected. You only have to change the format of the cells.
In my example in column H the format is date (Datum in german)
And in column G the format is standard (Standard in german)
- end up resolving by opening new page and puting all data back, formula was ok, but not sure cell format resolving in error
thanks for all your help