In EXCEL how do I get values other then true or false to display when using =OR()?

Question

I want to be able to display other characters other then true or false. For instance I want to display a check mark if the value is within tolerance of a data range and I want to to remain blank if it is out of tolerance.

Answer 1

=if(or(x,y),"A","B")

Answer 2

Use IF to do the test then you get to choose what gets displayed. Use the windows character map to find a check mark to display.

In excel help there is an excellent tutorial on IF

Answer 3

It should be like this
=IF( OR( A1=10, B1=12), "Found", "")

Using IF statement will do the trick

XLMan