LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I balance a chckbook? what is the formula? Cheryl Excel Worksheet Functions 2 October 4th 06 01:36 AM
rent received/balance owed/running balance spreadsheet Quickbooks dummy Excel Discussion (Misc queries) 1 January 2nd 06 07:34 PM
3D column chart with plane / surface added [email protected] Charts and Charting in Excel 1 April 19th 05 11:18 AM
can excel draw a chart in a coordinate plane larry S Charts and Charting in Excel 2 April 1st 05 11:14 PM
Balance sheet Formula TC Excel Discussion (Misc queries) 0 February 23rd 05 08:13 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"