Re: Further To Excel Table Question
Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Related Discussions
-
5
-
2
-
3
-
1
-
5
Excel Table Question
It must start by checking if cell B4 has a measurement in it (eg. B4>0) before checking all the conditions in Sheet2 ("Table 4.2Valid")(shown below):
it needs to check the information in the table as follows:-
(line1 or Line2 or line3 etc).
whichever line is correct it must display whatever is shown in the result column.
If no conditions are met, it must display the result in line6.
The table is on sheet2 OF MY EXCEL WORKBOOK and is called "4.2Valid" and is as follows:-
if short if long TTU? Result
1 NO YES YES 4.5
2 NO YES NO 4.5
3 YES NO YES 4.5
4 YES NO NO N/A
5 NO NO NO N/A
6 NO NO NO (LEAVE BLANK)
hope this makes sense.
Kind Regards
Del
This conversation is currently closed to new comments.