ExcelBanter - How do I set two different (AND & OR) logic functions within one

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I set two different (AND & OR) logic functions within one (https://www.excelbanter.com/excel-discussion-misc-queries/126808-how-do-i-set-two-different-logic-functions-within-one.html)

Short Term Trader

How do I set two different (AND & OR) logic functions within one

How would I write the following:
if cell 1 (OR) cell 2 is 5 (AND) if cell 3 (OR) cell 4 is < 5 then "true"

Dave F

How do I set two different (AND & OR) logic functions within one

IF(AND(OR(A15,A25),OR(A3<5,A4<5)),"TRUE","FALSE" )

Dave
--
Brevity is the soul of wit.

"Short Term Trader" wrote:

How would I write the following:
if cell 1 (OR) cell 2 is 5 (AND) if cell 3 (OR) cell 4 is < 5 then "true"

All times are GMT +1. The time now is 04:20 AM.