View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
turkyildiz turkyildiz is offline
external usenet poster
 
Posts: 7
Default I can balance a plane but i can not fix a formula.

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

According to argument

=IF(OR(B21MAX(Nose!$C$3:$AA$61),D21MAX(Nose!$A$3 :$B$61),C21MAX(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.