Excel If/Or Statement

Hello,

I have the following Excel formula:

=IF(OR(K46:K52)="Yes","Additional Items","")

I would like to alter it so that if any cell between K46:K52 is "Yes", the cell would return the value "Additional Items" - otherwise the cell would return blank.

Is this possible?

Thanks
LVL 1
dabug80Asked:
Who is Participating?
 
Michael FowlerSolutions ConsultantCommented:
=IFERROR(IF(MATCH("Yes", K46:K52, 0) > 0, "Additional Items"),"")

Open in new window

0
 
Wilder1626Commented:
Hi

Is this what you are looking for:

=IF(K46:K51 = "Yes","","Additional Items")

Open in new window


In what cell do you put your formula?
0
 
Wilder1626Commented:
Another way could be:
=IF(OR(K46:K51 = "Yes"),"","Additional Items")

Open in new window

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
dabug80Author Commented:
I've tried both solutions, and they each return the #value error. The formula works when the range is just K46 - but when I increase the range, I get the #value error.
0
 
Michael FowlerSolutions ConsultantCommented:
@dabug80

Try my formula. It looks for a match within the range and when it is found it displays "Additional Items". The IFERROR function handles the case when the Match fails and displays an empty string
0
 
Michael FowlerSolutions ConsultantCommented:
Could also simplify this a bit
=IFERROR(IF(MATCH("Yes", K46:K52, 0), "Additional Items"),"")

Open in new window

0
 
dabug80Author Commented:
Great. Thanks for your help Michael. Works perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.