Help Needed to Create an Excel

[Sinone]

Hello everyone,


         I have an issue with my excel coding, for some of you that might know how to use it could be EASIER. I would like to explain my request and if someone can help please, I would appreciate!

I have an excel file, on which I keep open while I am playing roulette. Every-time a number comes, I want to just type that number in the cell and automatic to register the attributes of that number in all the other cells.

-Thus. Number 5

A3 I type number 5 then equal for B3 RED, C3 LOW, D3 1ST DOZEN, E3 2ND COLUMN, F3 ODD, G3( Is the cell that counts the total of 1-9 H3 the total of 10-19 I3  20-19  J3 30-36 )  automatic adds one value to that cells regarding the number that I input.

-Thus Number 28

A4 I type 28 - Which is BLACK, HIGH, 3RD DOZEN, 1ST COLUMN, EVEN, AND BETWEEN 20-29 TOTAL

- Thus 0

I type 0 and it doesn't register anything just the total spins goes +1 - and cell A1 show neutral +1

I look forward hearing from you,

Sinone

[Nickmsi]

Hello and welcome to the forum.

I sent you a PM regarding your sheet.

Nick