If/and statement

[bj6264]

Hello can anyone help with a if/and statement in Excel? I'm looking for a formula to indicate whether the resulting value is >= plus or minus 10%. I can complete a formula for one of the values but cannot seem to combine the 2 together

 

[SteveO59L]

something along the lines of

=IF(ABS(A1-B1)<=10,"ok","error")

 

[bj6264]

Hello Steve, Thanks for this but my value I'm trying to get this formula on is in one cell only so this doesn't work in my instance. thanks B