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

If cell A1 has text then cell B2 has today's Date

Excel function question

Similar discussions

Subscribe To Our Newsletter!