Blogger
Share this content
0
2
2400

Tolerance

Does anyone know of an Excel formula / IF statement which will accept figures within a tolerance range, even though the answer is not precisely mathematically correct; e.g.

.............and upwards Reject
£100 x 17.5% = £17.56 Reject
£100 x 17.5% = £17.55 Accept
£100 x 17.5% = £17.54 Accept
£100 x 17.5% = £17.53 Accept
£100 x 17.5% = £17.52 Accept
£100 x 17.5% = £17.51 Accept
£100 x 17.5% = £17.50 Accept [mathematical true position]
£100 x 17.5% = £17.49 Accept
£100 x 17.5% = £17.48 Accept
£100 x 17.5% = £17.47 Accept
£100 x 17.5% = £17.46 Accept
£100 x 17.5% = £17.45 Accept
£100 x 17.5% = £17.44 Reject
.......and downwards Reject

Geoffrey Cox

Replies

Please login or register to join the discussion.

avatar
By Anonymous
16th Nov 2007 10:09

Conditional Formatting?
Can you not use conditional formatting?

Thanks (0)
avatar
01st Dec 2007 15:31

Data Validation
Go to Data - Validation - Allow - Whole Number and select the ranges that contain the parameters.

Thanks (0)