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?

"Idaho" wrote:
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 -----

"Idaho" wrote in message
...
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?