Forum Discussion

Copper Contributor

Jan 20, 2023

If

=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

excel

OliverScheurich

Gold Contributor

Jan 20, 2023

Ana_Guerra

=SE(G24>50;ANO(I24)+1;SE(G24<50;ANO(I24)+2;""))

You can try this formula.

Ana_Guerra
Copper Contributor
Jan 20, 2023
the same
note that
cell E has a formula =ANO(D24)-ANO(E24)

OliverScheurich
- OliverScheurich
  Gold Contributor
  Jan 20, 2023
  Ana_Guerra
  =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?
  - Ana_Guerra
    Copper Contributor
    Jan 20, 2023
    OliverScheurich
    
    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;""))"