Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Nested if statment not working

Hi

The below if statement is not working. I dont know why. It is only calculating values for the <4 part not the =4 or =5 part.

if([Intervall RD]<'4',[Rörlig Lön]*[Procent RD],

if([Intervall RD]='4',[Rörlig Lön]*%AvBudget,

if([Intervall RD]='5',[Rörlig Lön],0)))

as Utbetalt

I am happy for any help to solve this.

//Fredrik

10 Replies
Clever_Anjos
Employee
Employee

Just guessing, could you add [] around?

if([Intervall RD]<'4',[Rörlig Lön]*[Procent RD],

if([Intervall RD]='4',[Rörlig Lön]*[%AvBudget],

if([Intervall RD]='5',[Rörlig Lön],0)))