That doesn't seem to work for, say, P9 = 0.5

Perhaps

=1 + (P90) + (P9=2)

In article ,
Teethless mama wrote:

=LOOKUP(P9,{0,1,2},{1,2,3})


"Aaron Hodson (Coversure)" wrote:

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