Excel

[MarkyP05]

Formula based question

Which function do i use so that a specific cell produces a "20" if the random number produced in a different field matches a certain set of predefined numbers and a "0" if not.

thanks in advance

[ChuckFickens]

use the IF statement

http://www.lmgtfy.com/?q=excel+if+statement

[MarkyP05]

ive attempted to use that function... but to no avail

ive tried =IF((B1=A1,A2,A3),"20","0")

with A1, A2, A3 being the pre-defined numbers AND B1 being the random number but its not accepting it

[factor-fiction]

Are your brackets right- are you sure the brackets should surround everything that follows?

[R1Geezer]

Try this:

=IF(OR(B1=A1,B1=A2,B1=A3),20,0)

You seemed to be coding an AND condition.

[ChuckFickens]

also unless you are planning on never changing the numbers you'd be better off putting them in separate cells and referencing the cells in the formula rather than having the numbers in the formula.

[R1Geezer]

chuck, look closely we are referencing the cells! They are A1/A2/A3.

[ChuckFickens]

DOh!

I was tired, it was late :)

[dipee65]

Have you tried if(B1=A1) OR (B1=A2) OR (B1=A3) inside the formula?

[R1Geezer]

that's what I coded dippy

[MarkyP05]

worked a treat. thanks.