Onthegrind2
New Member
- Joined
- Oct 15, 2012
- Messages
- 32
Hi,
I need to know how to write a formula so if the result is a minus number, it just displays "0.0000".
For example, I want the formula to determine how much out of tolerance a particular feature is, based on values from cells G3 & H3. So cell G3 has the actual position, and H3 contains the position G3 has to be within. So G3 would have something like "0.0100" and the H3 cell would contain "0.0150". I would want the result to be "0.0000", because G3 it is not out of tolerance at all. But if the numbers were reversed, I'd want the answer to be the difference, or "0.0050".
Thanks for any help.
I need to know how to write a formula so if the result is a minus number, it just displays "0.0000".
For example, I want the formula to determine how much out of tolerance a particular feature is, based on values from cells G3 & H3. So cell G3 has the actual position, and H3 contains the position G3 has to be within. So G3 would have something like "0.0100" and the H3 cell would contain "0.0150". I would want the result to be "0.0000", because G3 it is not out of tolerance at all. But if the numbers were reversed, I'd want the answer to be the difference, or "0.0050".
Thanks for any help.