Question about Microsoft Excel for PC

2 Answers

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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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. Add

×

Loading...
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

3 Answers

I forgot the pattern of locking and i tried too many pattern on my karbonn a2 mobile how to open the same?


http://forum.gsmhosting.com/vbb/f824/karbonn-a2-hard-reset-solu-here-1681950/

Dec 11, 2014 | Karbonn K9

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

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

83 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...