stacking if functions
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? |
stacking if functions
"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? |
All times are GMT +1. The time now is 10:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com