Microsoft Nested If statements with if, then, else

Question

Bennita Martin 0 Newbie Poster

17 Years Ago

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

microsoft-access

3 Contributors
2 Replies
115 Views
6 Months Discussion Span
Latest Post 17 Years Ago Latest Post by Rupeshba

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

jlopez 0 Newbie Poster · Answer 1 · 2006-10-04T17:05:40+00:00

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

Rupeshba 0 Newbie Poster · Answer 2 · 2007-03-31T11:05:27+00:00

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