Hi,
I have this formula:
Formula:Please Login or Register to view this content.
Can 2 more criteria be added to filter movies? This should be "AND" condition so that all criteria apply.
Thank you for your help
Hi,
I have this formula:
Formula:Please Login or Register to view this content.
Can 2 more criteria be added to filter movies? This should be "AND" condition so that all criteria apply.
Thank you for your help
That is an AND formula. If you really mean OR, then try this:
In Venn diagramme terms, AND is the intersection, whereas OR includes everything.Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the option.
I get mixed up trying to add the other criteria so there are 6 criteria total.
I prefer they be "AND" condition for now.
So what are the two extra criteria? And what happened when you tried to add them?
Please Login or Register to view this content.
I can't keep track of the parenthesis.
I will try again.
I am not getting any results when I select rating range.
I think the formula is correct but my reference must be off.
Can you please check?
PS I found my issue. I was referencing Ratings instead of Rating Range.
It's all good now.
Last edited by billy60; 02-29-2024 at 10:27 AM.
You're welcome.
Oh sorry I forgot to thank you.
I really do appreciate your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks