Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions