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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote:
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,MATC H($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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Apr 13, 10:10 pm, Ron Rosenfeld wrote:
On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote: Please seehttp://nzcargoops.com/np.xlsfor 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,MATC H($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- Hide quoted text - - Show quoted text - Ron, you are absuletly right, It is working like charm Thanks, |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote:
On Apr 13, 10:10 pm, Ron Rosenfeld wrote: On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote: Please seehttp://nzcargoops.com/np.xlsfor 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,MATC H($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- Hide quoted text - - Show quoted text - 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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Apr 14, 10:34 am, Ron Rosenfeld wrote:
On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote: On Apr 13, 10:10 pm, Ron Rosenfeld wrote: On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote: Please seehttp://nzcargoops.com/np.xlsforexcel 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,MATC H($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- Hide quoted text - - Show quoted text - 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 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. |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 14 Apr 2007 10:29:23 -0700, "turkyildiz" wrote:
On Apr 14, 10:34 am, Ron Rosenfeld wrote: On 14 Apr 2007 07:11:10 -0700, "turkyildiz" wrote: On Apr 13, 10:10 pm, Ron Rosenfeld wrote: On 13 Apr 2007 19:39:48 -0700, "turkyildiz" wrote: Please seehttp://nzcargoops.com/np.xlsforexcel 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,MATC H($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- Hide quoted text - - Show quoted text - 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 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 |
Reply |
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) |