Ne0ksCopper ContributorDec 08, 2022Formulas 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...Show More
dscheikeyBronze ContributorDec 09, 2022Ne0ks 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.
