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>
[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]Year of Create[/TH]
[TH]Year Of Renov[/TH]
[TH]Year of Apprais[/TH]
[TH]Effective Age[/TH]
[/TR]
[TR]
[TD]2009[/TD]
[TD]0[/TD]
[TD]2017[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]2011[/TD]
[TD]2017[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]2005[/TD]
[TD]2017[/TD]
[TD]11 (Error)[/TD]
[/TR]
</tbody>[/TABLE]

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.