• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with IF AND statement

S

Segurde

New Member
Hello,
I am looking to put together a formula that does the following IF L5=”X Rewards” and M5=”CentsOff”, then check that R5=”PT”. If true, return TRUE. If false, return FALSE.
I need to repeat this for all of the below scenarios:

IF L5=”Gas Rewards” and M5=CentsOff”, then check that R5=”PT”. If true, return TRUE. If false, return FALSE.
IF L5=”% Off” and M5=PercentOff”, then check that R5=”PE”. If true, return TRUE. If false, return FALSE.

IF L5=”dollar off” and M5=”CentsOff”, then check that R5=”CE”

If the two first conditions are not met, should return N/A or VALUE.
 
Not sure about the question:

=IF(AND(OR(L5="X Rewards",L5="Gas Rewards",L5="Dollar Off",L5="% Off"),M5="Centsoff"),IF(OR(R5="PT",R5="PE",R5="CE"),TRUE,FALSE))
 
You must log in or register to reply here.
Back
Top