Problems with IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(B12>C4;IF(B12<=D4;((((B12-C4)/(D4-C4))*0,5)+0,5)));IF(B12>D4;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(B12>C4;IF(B12<=D4;(((B12-C4)/(D4-C4))*0,5)+0,5,IF(B12>D4;1;0))))))
 
Hi Belli

Maybe
IF(B12<B4;0;
IF(AND(B12>=B4;B12<=C4);((B12-B4)/(C4-B4))*0,25)+0,25);
IF(AND(B12>C4;B12<=D4);((B12-C4)/(D4-C4))*0,5)+0,5);
IF(B12>D4;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
 
Back
Top