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 "";""
[Solved] IF/AND/OR Formula
[Solved] IF/AND/OR Formula
Last edited by jstack on Thu Jun 14, 2018 2:24 am, edited 1 time in total.
OpenOffice 4.1.2 on Windows 7
Re: IF/AND/OR Formula
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.