To start with, if you want a value in C3, you put your formula in C3, not in
P10. A formula can't "push" data into another cell.

The formula in C3 is =IF(P9<0,"undefined output",IF(P9=0,1,IF(P9<2,2,3)))
--
David Biddulph

"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