Excel 2007 : IF function guess the number

[bdiplastica]

Hi everyone!

I am trying to work on a very easy function (If) but my formula comes out wrong in excel 2007. I can't correct the mistake though. Here is what I am doing:
A1 Random number
A2 Guess the number (1-1000)
A3 The number you guessed is
B1=INT(RAND()*1000+1)
B3=IF(B1=B2;"correct";IF(B2>B1;"too big";"too small"))

Where is the error?

Thanks for the help

[zbor]

Work for me.

You can just easily use RANDBETWEEN function, but result is same (only your is greater then 1))

=RANDBETWEEN(1;1000)

[fiddle2oons]

Your example contains semicolons ";"
try commas ","
=IF(B1=B2,"correct",IF(B2>B1,"too big","too small"))