Hi guys ,

I have a supplier who is using thee CFG-1003 form and he told me he met a very strange problem.

looked at the attachedment .
item 2 and item 3 - the data should fall into the range but the result is NOT ok ... is there a specific reason for that ?

any help is appreciated !

thanks

Howdy Caine,

I cannot attach files (or am not bright enough this morning to figure out how).

If you'll paste this into o11: =IF(C11="basic","X",IF(MAX(I11:N11)>(F11),"",IF(MIN(I11:N11)<(E11),"","X")))

and this into p11: =IF(C11="basic","",IF(MAX(I11:N11)>(F11),"X",IF(MIN(I11:N11)<(E11),"X","")))

Then drag copy them for the complete columns, it will correct the logic flaw. You'll also have to fill column E with the actual minimum spceifications.

Final note, item #10, you'll have to remove the "N"'s and leave results in numeric format for the formula to be able to work.

There may be a better way, but this will work.

Fen

I cannot attach files (or am not bright enough this morning to figure out how).

File Attachments - How to Attach a File to a Post in a Thread (http://elsmar.com/Forums/showthread.php?t=10668)

Good morning again,

I must have taken the short bus in to work today. I had read the instructions for posting attachments but failed to see the rather large green 'Reply" button. I'd been using the quick reply button all along. Call me a noob. Thanks for help me out :)

Anyhow, please see attached.

Hi guys ,

I have a supplier who is using thee CFG-1003 form and he told me he met a very strange problem.

looked at the attachedment .
item 2 and item 3 - the data should fall into the range but the result is NOT ok ... is there a specific reason for that ?

any help is appreciated !

thanks
Hi,

The form only works correctly with numbers, not degrees or "N".

The cells you highlighted should have just numbers such as 90 for the angle nominal. For angles you have to convert the minutes to a decimal notation (30 ' is 0.5 degrees).

Remove the "N" from the force values and replace 30-50N with 40 with a spec. limits of 20 and 50 (no "N")

I would not change the formulaes in the form.

thanks everyone's help on this issue ! really appreciated !