Check if Fomula Error

[muhammad susanto]

hi all..

i'm looking for formula to check or show if error
this table:
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

Year of Create	Year Of Renov	Year of Apprais	Effective Age
2009	0	2017	8
2009	2011	2017	7
2009	2005	2017	11 (Error)

<tbody>
</tbody>

this formula :

=IF(OR(F2=0;F2="-";ISBLANK(F2));G2-E2;ROUND(((G2-E2)+(2*(G2-F2)))/3;0))

rule :
- year of renov must greater than year of create (YR>YC)

i want formula can showing or detect if the result error, how to modify that formula above
any help greatly appreciated

sst

 

[Aladin Akyurek]

Looks like:

=IF(ISNUMBER(E2),IF(ISERROR(1/F2),G2-E2,IF(F2>=E2,ROUND(((G2-E2)+(2*(G2-F2)))/3,0),"error: year of renov")),"")

 

[muhammad susanto]

hi Aladin, wow worked great!!!

Thank you so much..

 

[Aladin Akyurek]

hi Aladin, wow worked great!!!

Thank you so much..

You are welcome.