This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello to everybody,
I have plenty of this formula with OR and AND nested functions/conditions:
=IF(OR(AND(PAIRS!E59="BUY";PAIRS!E61="BUY";PAIRS!E63="BUY";PAIRS!E65="BUY");OR(PAIRS!E67="BUY";PAIRS!E83="BUY";PAIRS!E81="BUY";PAIRS!E89="BUY");OR(PAIRS!E69="BUY"));"MN trend BUY";"")
=IF(OR(AND(PAIRS!H5="BUY";PAIRS!H7="BUY";PAIRS!H9="BUY";PAIRS!H11="BUY";PAIRS!H13="BUY";PAIRS!H21="BUY");OR(PAIRS!H15="BUY";PAIRS!H17="BUY"));"W1 Trend Buy";"")
Is there please a way to shorten or write the formula is a better and readable way?
Thank you in advance.
Regards John
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
As a small side note:
OR(Pairs!E67 = "BUY", Pairs!E83 = "BUY", Pairs!E81 = "BUY", Pairs!E89 = "BUY"),
OR(Pairs!E69 = "BUY")
Or(a,b,c), Or(d) can be simplified to just Or(a,b,c,d)
Answer accepted by question author
Difficult to say without seeing the lay-out of your schedule and without knowing what Excel version you are using.
The 2nd formula references 5 alternating rows like H7, H9, H11, H13 and H15. Then it hops over 7 rows and references H21. Could you re-design the schedule so that you can address entire ranges rather than individual cells?
With a modern Excel version, the formula could then look something like this (note my Excel version uses commas to separate function arguments):
=IF(OR(SUM(--(PAIRS!H5:H10="BUY"))=6,SUM(--(PAIRS!H12:H13="BUY"))>0),"W1 Trend Buy","")
And I'm sure others can come-up with alternatives.
Thank you for your answer and much better solution than mine.
I'll revise the project to avoid mistakes in my "old" formulas.
Thansk again.
Regard John.