Hi Belli

Maybe
IF(B12<B4;0;
IF(AND(B12=B4;B12<=C4);((B12-B4)/(C4-B4))*0,25)+0,25);
IF(AND(B12C4;B12<=D4);((B12-C4)/(D4-C4))*0,5)+0,5);
IF(B12D4;1,0,"something_else"))))

The "something_else" is to deal with a case where B12 is not less than
B4 and is not greater than D4

--
Regards

Roger Govier


"Bell" wrote in message
...
Unfortunately Excel won't accept below formula and I can't figure out
why.
Any suggestions? I'm using a European version so I know the ; dividing
the
criterias are correct.

IF(B12<B4;0;IF(B12=B4;IF(B12<=C4;((((B12-B4)/(C4-B4))*0,25)+0,25)));IF(B12C4;IF(B12<=D4;((((B12-C4)/(D4-C4))*0,5)+0,5)));IF(B12D4;1,0)

Many thanks in advance.