Formulas IF , then

[Ne0ks]

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 :) 

[#2]

@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.