# IF formula to calculate a deviation of +- .5%

1. ## IF formula to calculate a deviation of +- .5%

Hi all,

I'm creating a spread sheet and I need a formula to calculate a deviation of half a percent of error.

My current formula will only calculate the error if its a positive number .0500 but if its negative like -6.003 it still recognizes it as good which it isn't.

Any help would be greatly appreciated.  Register To Reply

2. ## Re: IF formula to calculate a deviation of +- .5%

Build an If at the beginning  Register To Reply

3. ## Re: IF formula to calculate a deviation of +- .5%

Hi Jeff

Thanks for your help, here's what I've got, which works on the +.5% but as soon as it dips into the negative numbers it registers as fail even though the deviation is still within the +-.5%

=IF(F41<0,"Fail",IF(F41<C41,"Pass","Fail"))  Register To Reply

4. ## Re: IF formula to calculate a deviation of +- .5%

Hi mikey,

How about a quick sample workbook with the values you have and what you expect?  Register To Reply

5. ## Re: IF formula to calculate a deviation of +- .5%

No problem let me get it doctored up for ya and will post shortly

Thanks again and much appreciated  Register To Reply

6. ## Re: IF formula to calculate a deviation of +- .5%

Here it is and let me know if you need me to explain in more detail

Thanks again  Register To Reply

7. ## Re: IF formula to calculate a deviation of +- .5%

I'm sorry mikey, but not quite clear on what you're needing here.  Register To Reply

8. ## Re: IF formula to calculate a deviation of +- .5%

In E38 for example
Formula:  `Please Login or Register  to view this content.`
Is that what you are looking for?  Register To Reply

9. ## Re: IF formula to calculate a deviation of +- .5%

the error is half a percent, .5% but the as long as the error in column G is with in the range whether it be positive or negative it would pass.

ex 20.000 is the reference so 20.081 (%error in G57 would be 0.500) and 19.920 (%error in G57 would be -0.500) these are still good an reference a pass in E41 and G41 for the As found and As left tables. Anything outside of that would reference a Fail.

Hope that makes more sense  Register To Reply

10. ## Re: IF formula to calculate a deviation of +- .5%

Hi ChemistB,

You my friend are getting a Christmas card this year!! Do you like puppies or kittens? thank you so much that worked!

Thanks to JeffreyBrown as well for your help too  Register To Reply

11. ## Re: IF formula to calculate a deviation of +- .5%

You are very welcome and thanks for the feedback. We are happy to help, but Brian did the real work in-which I am very thankful to him.  Register To Reply

12. ## Re: IF formula to calculate a deviation of +- .5%

Will do, and thanks again to both of you gentleman for the quick help. Stay safe  Register To Reply