END OF SERVICE CALCULATION

[Tia]

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

 

[Tom van Stiphout]

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

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

 

[KARL DEWEY]

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