Hello.


I just wondered if somebody could help me with IF statements.

I'll explain my situation first - I'm testing out a little system for the roulette wheel and want to see my expected profit after 1,000 spins. I have randomly generated 1,000 numbers and these are in a spreadsheet.

What I want to do is create an IF statement that will go something like this -

IF A1 is between 1 and 12 then dsiplay "-5", IF A1 is 12, 16, 18, etc display "45"

I just don't know how to correctly write the formula.

Thanks.