IF/IF Not Statement Assistance

[Disarmonious]

I'm trying to figure out a formula that would return a value of "?" if a certain cell was not a group of numbers. Example: I want Cell A2 to display a question mark if the user does not enter the numbers 10, 15, 20, or 25.

 

[Joe4]

Are you talking about returning that value to the same cell that they are trying to enter that number into, or should the formula in A2 look at the entry in another cell (i.e. A1)?

If the later, you can use a formula like this:

=IF(OR(A1=10,A1=15,A1=20,A1=25),A1,"?")

Otherwise, if you want it to do the same cell, you will probably need to use Data Validation (but that won't put a question mark in the cell, but rather prevent certain entries), or VBA.

 

[Scott Huish]

=if(or(a1={10,15,20,25}),a1,"?")

 

[Disarmonious]

Jo4,

Thank you for your assistance. This formula works out great!

 

[Disarmonious]

Scott,

I'll try that formula too, thank you for your help.