END OF SERVICE CALCULATION

Dear all,
i am sorry for disturbance, iam trying t move my data frm the excel
to access and i am having troubles with the formulas, i am trying to
calculate the total gratuity of the end of service i used to use this
formula
=IF(AND(K8="Termination",(Total working years)=1),TEXT(((Total
Package per day)*(Total working years)*21),"#,#00.00")&" + "&"Ticket",
IF(AND(K8="Resignation",(Total working years)=1,(Total working years)
=3),(Total Package per day)*(Total working years)*7,IF(AND
(K8="Resignation",(Total working years)3),
(Total Package per day)*(Total working years)*21,"Service is less than
1 year")))

K8= CAN BE RESIGNATION AND SOMETIMES TERMINATION

tHANK YOU IN ADVANCE

On Mon, 16 Nov 2009 01:43:40 -0800 (PST), Tia
wrote:

It's hard to follow your expression, but it appears you want a few
nested IIF statements. Look it up in the help file. Build them up one
level at a time, e.g.
=iif(Me.K8="Termination", "some T stuff", "some R stuff")

-Tom.
Microsoft Access MVP



Dear all,
i am sorry for disturbance, iam trying t move my data frm the excel
to access and i am having troubles with the formulas, i am trying to
calculate the total gratuity of the end of service i used to use this
formula
=IF(AND(K8="Termination",(Total working years)=1),TEXT(((Total
Package per day)*(Total working years)*21),"#,#00.00")&" + "&"Ticket",
IF(AND(K8="Resignation",(Total working years)=1,(Total working years)
=3),(Total Package per day)*(Total working years)*7,IF(AND
(K8="Resignation",(Total working years)3),
(Total Package per day)*(Total working years)*21,"Service is less than
1 year")))

K8= CAN BE RESIGNATION AND SOMETIMES TERMINATION

tHANK YOU IN ADVANCE

When using multiple test in an IIF the AND goes betweem the test. Use
brackets to enclose field names.
Try this --
=IIF(K8="Termination" AND [Total working years]=1, Format([Total Package
per day]*[Total working years]*21,"#,#00.00") &" + Ticket",
IIF(K8="Resignation" AND[Total working years]=1 AND [Total working
years]=3, [Total Package per day]*[Total working years]*7,
IIF(K8="Resignation" AND [Total working years]3), [Total Package per
day]*[Total working years]*21,"Service is less than 1 year")))

--
Build a little, test a little.


"Tia" wrote:

Dear all,
i am sorry for disturbance, iam trying t move my data frm the excel
to access and i am having troubles with the formulas, i am trying to
calculate the total gratuity of the end of service i used to use this
formula
=IF(AND(K8="Termination",(Total working years)=1),TEXT(((Total
Package per day)*(Total working years)*21),"#,#00.00")&" + "&"Ticket",
IF(AND(K8="Resignation",(Total working years)=1,(Total working years)
=3),(Total Package per day)*(Total working years)*7,IF(AND
(K8="Resignation",(Total working years)3),
(Total Package per day)*(Total working years)*21,"Service is less than
1 year")))

K8= CAN BE RESIGNATION AND SOMETIMES TERMINATION

tHANK YOU IN ADVANCE
.