Question about Microsoft Excel for PC

# If condition problem

Hi....

How to use the multiple cells in if condition.

=if(A2="Car","Yes","No") (This working)

=if(A2:A15="Car","Yes","No") (Please Answer)

Posted by on

Ad

## 2 Answers

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor
• 27 Answers

Are you trying to find out if ALL cells have "car" -OR- if ANY cells have "car"?

If ALL cells have "car" try this:

=IF (COUNTIF(A2:A15,"car") = 14,"Yes","No")

If ANY cell has "car" try this:

=IF (COUNTIF(A2:A15,"car") > 0,"Yes","No")

Hope this helps.

Posted on Dec 21, 2007

Ad
• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor
• 14 Answers

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(A5<>"Car","No",IF(A6<>"Car","No",IF(A7 <>"Car","No","Yes")))

So in this example if A5, A6, and A7 all equal car then you will get a return of Yes, but if any of them don't you will get a No.

Posted on Dec 21, 2007

Ad

## 1 Suggested Answer

• 2 Answers

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

1 Answer

### What is it b1318 on 00 mercury cougar

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

Jan 26, 2015 | 2000 Mercury Cougar

2 Answers

### Need to have a certain cell say OFF when it is a certain day

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.

Jun 06, 2010 | Microsoft Excel for PC

1 Answer

### Webcams for Apple and Windows PC

Nov 12, 2009 | Computers & Internet

1 Answer

### Wages bill reg

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"

Apr 16, 2009 | Microsoft Excel for PC

2 Answers

### Excel formulas

hello
yes it is.
example

sheet1
A1 (50)
A2 (50)

sheet2

(A1)=
"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain
in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?
dont know else how I should explain it...
good luck

Oct 09, 2008 | Microsoft Excel for PC

2 Answers

### Formula for calculating the days beween months

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)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

### Sumproduct or conditional sumif with multiple criteria in vba code...

i'll just reply to your conditional sumif query.

yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:

{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria

initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))

then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.

Jun 27, 2008 | Microsoft Excel for PC

2 Answers

### Formular to show number and cell references

The formula for A1 is: =SUM(B4,B5)
A2 is: =SUM(C4,C5)
A3 is: =SUM(A1:A2)

To test this, put 25 in cell B4, 25 in cell B5, then 30 in cell C4, and 30 in cell C5.....the result in cell A3 is 110.

Hope this helps.

Mar 07, 2008 | Microsoft Excel for PC

1 Answer

### Need help

hi i would only use 1 of then in the bote then just plug the speeker whire in to it

Dec 23, 2007 | DLS A1 Car Audio Amplifier

#### Related Topics:

83 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

3015 Answers

Level 3 Expert

18429 Answers

Level 3 Expert

2678 Answers

Loading...