Hi, How can I combine this two iIF formula into one..
IIf( [LeaveTypeID] =1 AND ([MEPNumber]>200,0,[BasicSalary])
IIf( [LeaveTypeID] =1 AND ([MEPNumber]<200,0,[BasicSalary]/30*21)
The formula above will give me a result of "0" if the "LeavetypeID" is not equal to 1 or should I say any number except 1.
But if the "LeavetypeID" is other than "1" it will check the next argument, which is "MEPNumber".... if it is >200 it should give me the value of "BasicSalary" ....and if "MEPNUmber" is <200 it should give me "BasicSalary / 30*21"
IIf( [LeaveTypeID] =1 AND ([MEPNumber]>200,0,[BasicSalary])
IIf( [LeaveTypeID] =1 AND ([MEPNumber]<200,0,[BasicSalary]/30*21)
The formula above will give me a result of "0" if the "LeavetypeID" is not equal to 1 or should I say any number except 1.
But if the "LeavetypeID" is other than "1" it will check the next argument, which is "MEPNumber".... if it is >200 it should give me the value of "BasicSalary" ....and if "MEPNUmber" is <200 it should give me "BasicSalary / 30*21"