Forum Discussion

Ne0ks's avatar
Ne0ks
Copper Contributor
Dec 08, 2022

Formulas IF , then

Hi all,

 

I want to set up an formula as follow:

If value is >3, then startyear can't be later than 25% from the cyclus from begin inspectiondate

 

So

=IF(A2>3; then cyclus (column N) = 15years *0,25=3,75 years
Inspection data (column DC) = 01-01-1900 + 3,75 years = 30-09-1904
Startyear in dataset (column L) = 2037
Value 1904 < then 2037 so True

 

I hope somebody can help me

Thanks in advance 🙂 

excel
Formulas and Functions

1 Reply

Sort By
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Dec 09, 2022

    Ne0ks 

    Maybe you can use EDAT().

    =EDATE("1900-01-01",(3.75*12))

    However, the result is "1903-10-01" depending on your formatting of the cell.

Resources