View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bell Bell is offline
external usenet poster
 
Posts: 5
Default Problems with IF statement

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.