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
Hard disk parts and functions - Guide
Excel functions in french - Guide
Linux combine split files - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Merging two instagram accounts - Need to make one username

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

Spreadsheet data

Similar discussions

Subscribe To Our Newsletter!