Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I balance a chckbook? what is the formula? | Excel Worksheet Functions | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
3D column chart with plane / surface added | Charts and Charting in Excel | |||
can excel draw a chart in a coordinate plane | Charts and Charting in Excel | |||
Balance sheet Formula | Excel Discussion (Misc queries) |