Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started