How to combine IF, AND, OR functions

Solved/Closed

MLC10 Posts 1 Registration date Friday February 5, 2021 Status Member Last seen February 5, 2021 - Updated on Feb 23, 2021 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 23, 2021 at 11:36 AM

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)????

How to combine IF, AND, OR functions
Combine notifications viber - Guide
Accessor and mutator functions c++ - Guide
What are the key functions of the supportassist for home pcs? - Download - Cleaning and optimization
Excel functions in french - Guide
Functions of spreadsheet - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Updated on Feb 23, 2021 at 11:37 AM

Hi MLC10,

Sure thing.

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

Best regards,
Trowa

Similar discussions

Spreadsheet data

formula if you have credit in one column, debit in next column

How to merge WhatsApp backup from old phone to same WhatsApp

Excel function question

Similar discussions

Subscribe To Our Newsletter!