stacking if functions

[Idaho]

I use spreadsheets for recording measured dimensions. I am trying to set up
my template so when I put the dimensoin in, it tells me if it is right or
not. for example: 2.25 has a minimum of 2.22 and a max of 2.28. How do I
format the if formula to reflect the .030 tolorance?

 

[JoeU2004]

I use spreadsheets for recording measured dimensions. I am trying to set
up my template so when I put the dimensoin in, it tells me if it is right
or
not. for example: 2.25 has a minimum of 2.22 and a max of 2.28. How do
I format the if formula to reflect the .030 tolorance?

Manys to do this. One way:

=if(abs(A1-2.25)>0.03, "bad", "good")


----- original message -----