I am trying to complete a deliverable with an acess database, below IS the formula that I used and it returned errors with the brackets and commas.

Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4, 100%.

I am trying to complete a deliverable with an acess database, below IS the formula that I used and it returned errors with the brackets and commas.

Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4,
100%.

IF your are putting this expression inside your calculated control, you can revise this one because in immediate iif statement you cannot put else statement

IIF([P1]<=4,"100%",IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" ))

IF your are putting this expression inside your calculated control, you can revise this one because in immediate iif statement you cannot put else statement

IIF([P1]<=4,"100%",IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" ))

Hi...

u have problem in

IIF([P1]<=4,"100%",IIF([P1]>12,0,IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" )))