Multiple if statement

Question

I have created a column to calculate total number of months employed(DateTimeDiff(DateTimeToday(),[Position Start Date],"months") and have labeled that column "Months Employed". I need to create an additional column with the below logic for

* If months 1-6 = Base Rate*1.15
* If months 7-9 = Base Rate*1.10
* If months 10-18 = Base Rate*.867
* If months 19+ = Base Rate

Any tips?

bpatel · Accepted Answer

hi @RyanSchilt ,

here is what i came up with. hope it helps.

ups366 · Accepted Answer

Dear , formula as below:

IIF([months employed]>18, [base rate], IIF([months employed]>9, [base rate]*0.867, IIF([months employed]>6, [base rate]*1.1, IIF([months employed]>0, [base rate]*1.15, '-'))))