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.