DaniWeb IT Discussion Community - Microsoft Nested If statements with if, then, else

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- MS Access and FileMaker Pro (http://www.daniweb.com/forums/forum128.html)

- - Microsoft Nested If statements with if, then, else (http://www.daniweb.com/forums/thread54942.html)

Bennita Martin

Sep 12th, 2006 11:59 pm

Microsoft Nested If statements with if, then, else

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

jlopez

Oct 4th, 2006 7:05 am

Re: Microsoft Nested If statements with if, then, else

Quote:

Originally Posted by Bennita Martin (Post 251785)

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

Mar 31st, 2007 1:05 am

Re: Microsoft Nested If statements with if, then, else

Quote:

Originally Posted by jlopez (Post 259741)

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

All times are GMT -4. The time now is 9:10 am.