Oops, still need help but,

The formula can go direct into C3 without the need for P10 existing,

Thanks again in advance of the reply.

Kind regards

Aaron

"Aaron Hodson (Coversure)" wrote in message
...
Hello everyone,

I am trying to get the following formula to work, without success.

I would like C3 to have 3 possible outcomes, 1,2 or 3. This data will be
sent by P10.
P10 should be (in simple):

IF P9 IS EQUAL TO 0 THEN C3 EQUALS 1
IF P9 IS GREATER THAN 0 AND LESS THAN 2 THEN C3 EQUALS 2
IF P9 IS EQUAL TO OR GREATER THAN 2 THEN C3 EQUALS 3

Your help is much appreciated as always,

Kind regards

Aaron