Question: Learning IF AND OR FUNCTIONS in EXCEL Increment the backers count by 5 if: The launched at month is January OR September The city is

Learning IF AND OR FUNCTIONS in EXCEL

Increment the backers count by 5 if:

The launched at month is January OR September

The city is Vancouver AND the country trimmed is Canada

If these conditions are not met, the backers-count stays the same.

M=BACKERSCOUNT

K=LAUNCHATMONTH JAN-1 SEPT-9

W=CITY

AA=COUNTRY TRIMMED

Can someone help me figure out what the formula is?

IF(OR(K2=1,K2=9)IF(AND(W2="VANCOUVER",AA2="CANADA")M2+5)??? IDK..

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Q:

I don't get the question mean... Please explain what should I write down it... This question related to Case Study which is attach the file... The question is What aspects of the implementation and...

Q:

Please help me to answer the attached files ................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1 Submission deadline without penalties is 12 October 2017....

Q:

Please help me to answer the following file ............................................................................................... INVESTMENT AND PORTFOLIO MANAGEMENT COURSE ASSESSMENT 1...

Q:

Total Score 0 100 76 76/10076 out of 100 Range75 to 84 Although there are no hard-and-fast cutoff scores for this assessment, your score suggests that you have moderate leadership skills. Leadership...

Q:

Please answer the questions on M1 Rubric document 3 pgs and essay format about the document attached. Include excel about data listed in rubric. You don't have to read the whole document just skim...

Q:

13-149 August 27, 2013 Nissan Motor Resiliency Company Ltd.: Building Operational William Schmidt, David Simchi-Levi On March 11, 2011 a 9.0-magnitude earthquake, among the five most powerful on...

Q:

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

Q:

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

Q:

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

Q:

Explain the requirements necessary for a scholarship to be tax-free to the recipient.

Q:

"Cash is only 3% of our total assets. Therefore, we should not waste time designing systems to manage cash. We should use our time on matters that have a better chance of affecting our profits." Do...

Q:

Laiho Industries: Balance Sheets as of December 3 1 ( thousands of dollars ) 2 0 2 1 2 0 2 0 Cash $ 1 0 2 , 8 3 0 $ 9 1 , 2 4 5 Accounts receivable. $ 1 0 3 , 0 3 4 . $ 8 4 , 7 7 4 Inventories. $ 3 7...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

KEY QUESTION Suppose that you hear two people arguing about energy. One says that we are running out of energy. The other counters that we are running out of cheap energy. Explain which person is...

Q:

ADVANCED ANALYSIS Suppose that a government wants to reduce its economys dependence on coal and decides as a result to tax coal mining companies $1 per ton for every ton of coal that they mine....

Q:

KEY QUESTION Use your demand schedule for a public good, determined in question 1, and the following supply schedule to ascertain the optimal quantity of this public good. Why is this the optimal...