• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

excel if and / or ... except

Hello Experts ...

here is a smaller scenario of what i have.

cell b1,c1,d1 can contain X or Y.
If any of the cells contain X, then place A in cell A1, unless any of the cells contain Y, in this case place a BLANK in cell A1.

used If or for the first part, which works well, but cant figure out the other part.

Karl Lalloo
Karl Lalloo
1 Solution

pls try

shorter version


Karl LallooAuthor Commented:
Thanks, will give it a try.

I did use a workaround though that gave me the results i needed .... used conditional formatting to change font to background colour.

Will let you know.

Thanks, K

Featured Post

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now