Formulas IF , then

Occasional Visitor

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  

1 Reply

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