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.

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.

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.

t