-2

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%.

3
Contributors
2
Replies
3
Views
11 Years
Discussion Span
Last Post by Rupeshba
0

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" ))

0

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" )))

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.