How to combine IF, AND, OR functions

Report
Posts
1
Registration date
Friday February 5, 2021
Status
Member
Last seen
February 5, 2021
-
Posts
2697
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 23, 2021
-
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)????

1 reply

Posts
2697
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 23, 2021
457
Hi MLC10,

Sure thing.

Here you go:
=IF(AND(OR(K2=1,K2=9),W2="VANCOUVER",AA2="CANADA"),M2+5,M2)

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!