IF OR Statement

[Human2014]

Hello everyone,

I am trying to write a formula in excel with the following:

IF(OR(F17,F18,F19)="YES",....,.....)

I discovered that I should write the following instead:

IF(OR(F17="YES",F18="YES",...,...,...)

I was wondering if there was any other quick way to write this formula as I have more than 200 rows and it might get my formula very slow.

Thank you

[Jdevil]

Do you mean that you are planning to use this formula in more than 200 rows, of that you want to check if over 200 different cells if they are equal to yes?

If you only have a few cells like in your example, having
IF(OR(F17="YES",F18="YES",F19="YES"),...,...)
won't be an issue if you only have "more than 200 rows", that should be fine. However, if you are planning to put a ton of cells like that, then you might wanna do something else instead. Using a helper column or something from your file might help, you may want to post a workbook in that case.

[Human2014]

What can I use instead?

If i have many rows and I want the file to work smoothly.

[Jdevil]

Well it really depends on what your file looks like, what you can do and what you're actually trying to do.

If, for example, you have a column with 500 values that can have anything in them, and want your formula to give you "Yes" if any of those cells contain a "Yes", then you could use VLOOKUP. Something like:
=IF(ISERROR(VLOOKUP("YES",F17:F500,1,FALSE)),[thing to do if there's not a yes],[thing to do is there's a yes])

[Aardigspook]

If all you want to do is check if a cell in a range (one or more) equals 'Yes', then try this:

Please Login or Register  to view this content.

If 'Yes' might be contained in a longer string (e.g. '2 - Yes') then use this instead:

Please Login or Register  to view this content.

Hope that helps.