Nested IF statements

[Angus Dow]

I need to write a formula which says if the difference between cell A1 and
cell A2 is less than .003 then "OK" if not wrong. Values of A1 can be
positive or negative in either case, i.e -.001 to .001 is OK .

Lots of attempts but no guaranteed result, I managed to conditional format
the results do they printed red and green but I would rather have OK or
wrong

It may be basic but it has stuck me.

Also is there anywhere on the web with lists of formulas like the one I need

Thanks

Angus

 

[Aladin Akyurek]

=IF(COUNT(A1:A2),IF(ABS(A1-A2)<0.003,"OK","Not OK"),"Not OK")

 

[CLR]

Hi Angus..........

Maybe
=IF(A1-B1<0.003,"OK","wrong")

Vaya con Dios,
Chuck, CABGx3

 

[Angus Dow]

Thanks Guys

will try both shortly

Angus

Hi Angus..........

Maybe
=IF(A1-B1<0.003,"OK","wrong")

Vaya con Dios,
Chuck, CABGx3

 

[Angus Dow]

Thanks Aladin that worked a treat

Angus

=IF(COUNT(A1:A2),IF(ABS(A1-A2)<0.003,"OK","Not OK"),"Not OK")

 

[hgrove]

Aladin Akyurek wrote...

=IF(COUNT(A1:A2),IF(ABS(A1-A2)<0.003,"OK","Not OK"),"Not OK")

...

Could be shortened

=IF(COUNT(1/(2*VAR(A1:A2)<0.003^2)),"OK","Not OK"