Jan 05 2021 07:30 AM
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
Jan 05 2021 07:41 AM
I'd suggest to change the order of percenatge
and use the formula as
=LOOKUP(D32,C34:C44,D34:D44)