Payroll_formula
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
CDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
start month1/1/122/1/123/1/124/1/125/1/126/1/127/1/128/1/129/1/1210/1/1211/1/1212/1/12
2
end month1/31/122/29/123/31/124/30/125/31/126/30/127/31/128/31/129/30/1210/31/1211/30/1212/31/12
3
term dateterm - start moterm - ntwk daysBENEFITSbase $$/mobase start datebase start monthbase end monthbase ntwk daysincrease $$/moincr start dateincr start monthincr end monthincr - ntwk daysbonus (1x)bonus datemonth ntwk days222122212321222320232221
7
8
correct$0$952$2,500$2,552$2,500$2,500$3,500$2,500$2,500$2,500$1,364$0
9
11/16/1211/1/12120$30,000$2,5002/20/122/1/122/29/128$1,200$1004/16/124/1/124/30/1211$1,0007/16/12actual$0$952$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$1,418$0
10
formulaIF($C9<V1,0, IF($C9<V2,SUM($H9+$N9)/V3*$E9, IF($I9<=V1,$H9, IF($I9<V2,$H9/V3*$L9, IF($O9<=V1,$N9, IF($O9<V2,$N9/V3*$R9, IF(AND($T9>=V1,$T9<V2),$S9,0)))))))
11
12
13
if TERM date is less STMO, $0FALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE0
14
if TERM date is less STMO, take $2500+$100 / curr.mo-ntwk days x term-ntwk daysFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSEFALSE1,4181,486
15
if BASE date less EOM, $2500 / curr.mo-ntwk days x start-ntwk daysFALSE9529099528709529098701,000870909952
16
if BASE date less/= STMO, $2500FALSEFALSE2,5002,5002,5002,5002,5002,5002,5002,5002,5002,500
17
if INCR date less EOM, $100 / curr.mo-ntwk days x incr-ntwk daysFALSEFALSEFALSE524852504855485052
18
if INCR date less/= STMO, $100FALSEFALSEFALSEFALSE100100100100100100100100
19
if MISC date great/= STMO & MISC date less EOM, $1000FALSEFALSEFALSEFALSEFALSEFALSE1,000FALSEFALSEFALSEFALSEFALSE
20
21
22
23
24
INDIVIDUAL CALCULATIONS
25
TERM$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$1,364$0
26
IF($C9<V1,0, IF($C9<V2,SUM($H9/V3)*$E9, IF($C9>=V1,$H9,0)))
27
28
29
BASE$0$952$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500$2,500
30
IF($I9<=V1,$H9,IF($I9<V2,$H9/V3*$L9,0))
31
32
33
INCR$0$0$0$52$100$100$100$100$100$100$100$100
34
IF($O9<=V1,$N9,IF($O9<V2,$N9/V3*$R9,0))
35
36
37
MISC$0$0$0$0$0$0$1,000$0$0$0$0$0
38
IF(AND($T9>=V1,$T9<V2),$S9,0)
Loading...
 
 
 
Sheet1