Formula issu in Excell. IF condition.

Copper Contributor

Hi,

Can anyone have a look at my SI (IF)  formula? 

Something is not going well.

PLease check CELL B44.

Should tell : if cell B32 <= A35:A43 ; Then result = column B 

 

B32 = number 

A35 = stage 

number can be between two stages

condition is "if below than ; then" 

Column B = result of stage

 

Would be super helpful. It's quite urgent.. 

Thank guys

1 Reply

@Micleiden 

I'd suggest to change the order of percenatge

image.png

and use the formula as

=LOOKUP(D32,C34:C44,D34:D44)