stacking if functions

I

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?
 
J

JoeU2004

Idaho said:
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?
Click to expand...

Manys to do this. One way:

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


----- original message -----
 
Top