I can balance a plane but i can not fix a formula.

[turkyildiz]

Please see http://nzcargoops.com/np.xls for excel sheet.

According to argument

=IF(OR(B21>MAX(Nose!$C$3:$AA$61),D21>MAX(Nose!$A$3:$B$61),C21>MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATCH($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

 

[Ron Rosenfeld]

Please see http://nzcargoops.com/np.xls for excel sheet.

According to argument

=IF(OR(B21>MAX(Nose!$C$3:$AA$61),D21>MAX(Nose!$A$3:$B$61),C21>MAX(Nose!
$C$1:$AA$1)),"No",IF(OFFSET(Nose!$C$3:$AA$61,MATCH($D$21,Nose!$A$3:$A
$61,-1)-1,MATCH(D21,Nose!$C$1:$AA$1,-1)-1,1,1)<C21,"No",

It should go to Nose Workbook and compare values and determine if
given dimensions would fit thru nose door of 747-400 Airplane.
L:2500
W:106
H:96

These dims are OK and above arguments Stays green and YES status but
if i increase Width to 107 inches forn does not turn to Red "No"
status instead it remains Green for up to 154 inches. I don't know
where i am making the mistake, Same argument works OK for Side Door
section of the sheet. If considering all the tables are correct i can
not find the problem. Any help is appreciated.

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:


....MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron

 

[turkyildiz]

I think you made an error in the last part of the formula. Probably you
dragged it from the Side Door formula and the relative references changed:

...MATCH(C21,Nose!$C$1:$AA$1,-1)-1,1,1)<B21,"No","Yes"))
^^^ ^^^
--ron- Hide quoted text -

- Show quoted text -

Ron,

you are absuletly right, It is working like charm
Thanks,

 

[Ron Rosenfeld]

Ron,

you are absuletly right, It is working like charm
Thanks,

You're welcome. Glad to help. We've been to NZ once -- and didn't stay long
enough. Maybe we'll be back for a longer stay some day.
--ron

 

[turkyildiz]

You're welcome. Glad to help. We've been to NZ once -- and didn't stay long
enough. Maybe we'll be back for a longer stay some day.
--ron

Ron,

On more question formula fixed but know very simple argument like 48 x
48 x 48 shows no and the answer should read yes.

 

[Ron Rosenfeld]

Ron,

On more question formula fixed but know very simple argument like 48 x
48 x 48 shows no and the answer should read yes.

Could there be a problem with your data table? The one you show on the
downloaded worksheet only as a few "2500's" filled in, and the rest is zero.
The sheet is protected so I cannot change it.
--ron