Try this one?

=IF(B12<G18;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))))))

"Bell" wrote:

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.