If ALL cells have to equal car to get a "yes" answer then this will work:
What I did was check to see if the value of the cell was not car. If the value is not car then it returns a "no" but if it does equal car then it moves on the the next cell or if statement.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Instrument Cluster Diagnostic Trouble Code (DTC) Index
DTC
Description
Source
Action
B1317
Battery Voltage High
Instrument Cluster
Go To Pinpoint Test C .
B1318
Battery Voltage Low
Instrument Cluster
Go To Pinpoint Test A . A1 CHECK THE BATTERY CONDITION
Carry out the Battery - Condition Test to determine if the battery can hold a charge and is OK for use. REFER to Section 414-01 .
Did the battery pass the condition test?
Yes
GO to A2 .
No
INSTALL a new battery. REFER to Section 414-01 . TEST the system for normal operation.
A2 CHECK THE GENERATOR OUTPUT
Carry out the Generator On-Vehicle Load Test and No Load Test. Refer to Component Tests in this section.
Did the generator pass the component tests?
Yes
GO to A3 .
No
INSTALL a new generator. REFER to Section 414-02 . TEST the system for normal operation
Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.
Format both cells with the time format "h:mm AM/PM".
Lets say the start time is in cell A2 and the stop time is in cell B2. In cell C2 put the formula =B2-A2 and custom format the cell C2 as: "h:mm"
for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...
cell A3......(properties set as General to show digits)................ =SUM(A2-A1)
×