[Solved] IF/AND/OR Formula

Discuss the spreadsheet application
Post Reply
jstack
Posts: 18
Joined: Wed Jun 13, 2018 10:28 pm

[Solved] IF/AND/OR Formula

Post by jstack »

Hello,
I'm trying to create a formula. I think I'm close but can't quite get it. Basically what I need is this: If A2=X AND B2=Y OR A2=XX AND B2=YY THEN "";""
Last edited by jstack on Thu Jun 14, 2018 2:24 am, edited 1 time in total.
OpenOffice 4.1.2 on Windows 7
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: IF/AND/OR Formula

Post by FJCC »

Your output seems to be "" regardless of the logic. In any case

Code: Select all

IF(OR(AND(A2 = X; B2 = Y); AND(A2 = XX;B2 = YY));"";"")
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
jstack
Posts: 18
Joined: Wed Jun 13, 2018 10:28 pm

Re: IF/AND/OR Formula

Post by jstack »

Wow, that appears to work. Thank you so much!
OpenOffice 4.1.2 on Windows 7
Post Reply