bonus disqualifiers for excess vacation days

K

kiki burgh

New Member
Joined
Jun 9, 2014
Messages
44
hope all is well everyone. may i seek your help for coming up with a template for computing for disqualifiers for a certain bonus given the following conditions (that sadly i cannot convert to formula):

folks are given bonus for completing work days in a month; however, due to being understaffed, taking vacation leaves that go beyond 10% of work days in a month is discouraged.

base bonus amount = 2,903.336 (subject to change monthly but is fixed for this specific example)

# of worked days in a month = 21 (other possible values of days worked: 19, 20, 22, 23)

10% of days worked
19 = 1.9
20 = 2
21 = 2.1
22 = 2.2
23 = 2.3

# days in excess of 10% of work days will incur increasing deductions
1 day = less 25% of base amount
2 days = less 50% of base amount
3 days = less 75% of base amount
4 days = less 100% of base amount

for example, month of june has 21 work days. an employee with exactly 2 (to at most 2.1) days approved & plotted vacation, will be rewarded 100% of base bonus amount whereas an employee with who filed for 4 days of leaves (4/21 = 19% has .9 excess days is definitely more than 10% of 21 work days of the month), will still be rewarded bonus but 50% less of base bonus amount compared to the other employee in prior example.

kindly see sample table below. for results shown in the attachment, these were just manually computed & referenced to tables. any approach or presentation to make it even leaner/better, will be greatly appreciated.

Code: 
[TABLE="class: grid, width: 526"]
<tbody>[TR]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]A[/SIZE][/TD]
[TD][SIZE=1]B[/SIZE][/TD]
[TD][SIZE=1]C[/SIZE][/TD]
[TD][SIZE=1]D[/SIZE][/TD]
[TD][SIZE=1]E[/SIZE][/TD]
[TD][SIZE=1]F[/SIZE][/TD]
[TD][SIZE=1]G[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A1[/SIZE][/TD]
[TD][SIZE=1]base bonus amount[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A3[/SIZE][/TD]
[TD][SIZE=1]# of work days[/SIZE][/TD]
[TD="align: right"][SIZE=1]10%[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]excess days[/SIZE][/TD]
[TD][SIZE=1]deduction[/SIZE][/TD]
[TD][SIZE=1]amount[/SIZE][/TD]
[TD][SIZE=1]total[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A4[/SIZE][/TD]
[TD="align: right"][SIZE=1]19[/SIZE][/TD]
[TD="align: right"][SIZE=1]1.9[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]1[/SIZE][/TD]
[TD="align: right"][SIZE=1]-25%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-725.834[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,177.502[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A5[/SIZE][/TD]
[TD="align: right"][SIZE=1]20[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD="align: right"][SIZE=1]-50%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-1451.668[/SIZE][/TD]
[TD="align: right"][SIZE=1]1,451.668[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A6[/SIZE][/TD]
[TD="align: right"][SIZE=1]21[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.1[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]-75%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-2177.502[/SIZE][/TD]
[TD="align: right"][SIZE=1]725.834
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A7[/SIZE][/TD]
[TD="align: right"][SIZE=1]22[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.2[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]-100%[/SIZE][/TD]
[TD="align: right"][SIZE=1]-2903.336[/SIZE][/TD]
[TD="align: right"][SIZE=1]0.000[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A8[/SIZE][/TD]
[TD="align: right"][SIZE=1]23[/SIZE][/TD]
[TD="align: right"][SIZE=1]2.3[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A9[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A10[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A11[/SIZE][/TD]
[TD][SIZE=1]Agent[/SIZE][/TD]
[TD][SIZE=1]Leave(s)[/SIZE][/TD]
[TD][SIZE=1]bonus[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A12[/SIZE][/TD]
[TD][SIZE=1]Agent 01[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A13[/SIZE][/TD]
[TD][SIZE=1]Agent 02[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A14[/SIZE][/TD]
[TD][SIZE=1]Agent 03[/SIZE][/TD]
[TD="align: right"][SIZE=1]2[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A15[/SIZE][/TD]
[TD][SIZE=1]Agent 04[/SIZE][/TD]
[TD="align: right"][SIZE=1]6[/SIZE][/TD]
[TD="align: right"][SIZE=1]0[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A16[/SIZE][/TD]
[TD][SIZE=1]Agent 05[/SIZE][/TD]
[TD="align: right"][SIZE=1]1[/SIZE][/TD]
[TD="align: right"][SIZE=1]2,903.336[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A17[/SIZE][/TD]
[TD][SIZE=1]Agent 06[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]1451.668[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A18[/SIZE][/TD]
[TD][SIZE=1]Agent 07[/SIZE][/TD]
[TD="align: right"][SIZE=1]4[/SIZE][/TD]
[TD="align: right"][SIZE=1]1451.668[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A19[/SIZE][/TD]
[TD][SIZE=1]Agent 08[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]2177.502[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A20[/SIZE][/TD]
[TD][SIZE=1]Agent 09[/SIZE][/TD]
[TD="align: right"][SIZE=1]3[/SIZE][/TD]
[TD="align: right"][SIZE=1]2177.502[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
[TR]
[TD][SIZE=1]A21[/SIZE][/TD]
[TD][SIZE=1]Agent 10[/SIZE][/TD]
[TD="align: right"][SIZE=1]5[/SIZE][/TD]
[TD="align: right"][SIZE=1]725.834[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[TD][SIZE=1]
[/SIZE][/TD]
[/TR]
</tbody>[/TABLE]

looking forward to your prompt help.
cheers.
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Sort by date Sort by votes
Which part do you need formulas for ??
Rows 4 to 8 are fairly simply calcs
and rows 12 to 21 are a simple VLOOKUP in column C ?
 
Upvote 0
Michael M said:
Which part do you need formulas for ??
Rows 4 to 8 are fairly simply calcs
and rows 12 to 21 are a simple VLOOKUP in column C ?
Click to expand...
hello michael m. it's great to see you are online. for the purpose of manual computation, i only showed columns F & G (which actually should not be included). values in Leave(s) column B are manual/pasted entries. i need help on bonus column c, which supposedly:
1) computes for what is/are excess day(s) on top of 10% of work days in a month (*note1 : days may not be exact, i.e., 1.8, 2.1, 3.5, etc.; **note 2: 4 & above excess depletes entire amount of base bonus amount)
2) then identifies what % the deduction will be
3) then computes for final amount

appreciate your help.
 
Upvote 0
Place a border around the entire block of spreadsheet data ( as shown in post #1), then copy that block of data and paste it into a reply post.
That way we don't have to redo the worksheet
 
Upvote 0
It's OK, I changed to another PC...


Try


Excel 2003
ABCDEFG
1base bonus amount$ 2,903.336
2
3# of work days10%excess daysdeductionamounttotal
4191.9125%$ 725.834$ 2,177.502
5202250%$ 1,451.668$ 1,451.668
6212.1375%$ 2,177.502$ 725.834
7222.24100%$ 2,903.336$ -
8232.3
9
10
11AgentLeave(s)bonus
12Agent 010$ 2,903.336
13Agent 020$ 2,903.336
14Agent 032$ 1,451.668
15Agent 046-
16Agent 051$ 2,177.502
17Agent 064-
18Agent 074-
19Agent 083$ 725.834
20Agent 093$ 725.834
21Agent 105-
Sheet1
Cell Formulas
RangeFormula
F4=($B$1*E4)
F5=($B$1*E5)
F6=($B$1*E6)
F7=($B$1*E7)
G4=$B$1-F4
G5=$B$1-F5
G6=$B$1-F6
G7=$B$1-F7
B4=A4*$B$3
B5=A5*$B$3
B6=A6*$B$3
B7=A7*$B$3
B8=A8*$B$3
C12=IF(B12=0,$B$1,IF(B12>=4,"-",VLOOKUP(B12,$D$4:$G$7,4,0)))
C13=IF(B13=0,$B$1,IF(B13>=4,"-",VLOOKUP(B13,$D$4:$G$7,4,0)))
C14=IF(B14=0,$B$1,IF(B14>=4,"-",VLOOKUP(B14,$D$4:$G$7,4,0)))
C15=IF(B15=0,$B$1,IF(B15>=4,"-",VLOOKUP(B15,$D$4:$G$7,4,0)))
C16=IF(B16=0,$B$1,IF(B16>=4,"-",VLOOKUP(B16,$D$4:$G$7,4,0)))
C17=IF(B17=0,$B$1,IF(B17>=4,"-",VLOOKUP(B17,$D$4:$G$7,4,0)))
C18=IF(B18=0,$B$1,IF(B18>=4,"-",VLOOKUP(B18,$D$4:$G$7,4,0)))
C19=IF(B19=0,$B$1,IF(B19>=4,"-",VLOOKUP(B19,$D$4:$G$7,4,0)))
C20=IF(B20=0,$B$1,IF(B20>=4,"-",VLOOKUP(B20,$D$4:$G$7,4,0)))
C21=IF(B21=0,$B$1,IF(B21>=4,"-",VLOOKUP(B21,$D$4:$G$7,4,0)))
 
Upvote 0
hi michael m. i am not sure what you meant by placing a border around the entire block of spreadsheet data but i hope what i've done below is right. the only difference of this table from the 1st post is the removal of columns f & g. thanks.
Code: 
[TABLE="class: grid, width: 401"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]base bonus amount[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]# of work days[/TD]
[TD="align: right"]10%[/TD]
[TD][/TD]
[TD]excess days[/TD]
[TD]deduction[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1.9[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]-25%[/TD]
[/TR]
[TR]
[TD]A5[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]-50%[/TD]
[/TR]
[TR]
[TD]A6[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]2.1[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]-75%[/TD]
[/TR]
[TR]
[TD]A7[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2.2[/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]-100%[/TD]
[/TR]
[TR]
[TD]A8[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]2.3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A11[/TD]
[TD]Agent[/TD]
[TD]Leave(s)[/TD]
[TD]bonus[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A12[/TD]
[TD]Agent 01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A13[/TD]
[TD]Agent 02[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A14[/TD]
[TD]Agent 03[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A15[/TD]
[TD]Agent 04[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD]Agent 05[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2,903.336[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A17[/TD]
[TD]Agent 06[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1451.668[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A18[/TD]
[TD]Agent 07[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1451.668[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A19[/TD]
[TD]Agent 08[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2177.502[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A20[/TD]
[TD]Agent 09[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2177.502[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A21[/TD]
[TD]Agent 10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]725.834[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Or this if you don't want columns F & G



Excel 2003
ABCDE
1base bonus amount$ 2,903.336
2
3# of work days10%excess daysdeduction
4191.9125%
5202250%
6212.1375%
7222.24100%
8232.3
9
10
11AgentLeave(s)bonus
12Agent 010$ 2,903.336
13Agent 020$ 2,903.336
14Agent 032$ 1,451.668
15Agent 046-
16Agent 051$ 2,177.502
17Agent 064-
18Agent 074-
19Agent 083$ 725.834
20Agent 093$ 725.834
21Agent 105-
Sheet1
Cell Formulas
RangeFormula
B4=A4*$B$3
B5=A5*$B$3
B6=A6*$B$3
B7=A7*$B$3
B8=A8*$B$3
C12=IF(B12=0,$B$1,IF(B12>=4,"-",$B$1*(1-VLOOKUP(B12,$D$4:$E$7,2,0))))
C13=IF(B13=0,$B$1,IF(B13>=4,"-",$B$1*(1-VLOOKUP(B13,$D$4:$E$7,2,0))))
C14=IF(B14=0,$B$1,IF(B14>=4,"-",$B$1*(1-VLOOKUP(B14,$D$4:$E$7,2,0))))
C15=IF(B15=0,$B$1,IF(B15>=4,"-",$B$1*(1-VLOOKUP(B15,$D$4:$E$7,2,0))))
C16=IF(B16=0,$B$1,IF(B16>=4,"-",$B$1*(1-VLOOKUP(B16,$D$4:$E$7,2,0))))
C17=IF(B17=0,$B$1,IF(B17>=4,"-",$B$1*(1-VLOOKUP(B17,$D$4:$E$7,2,0))))
C18=IF(B18=0,$B$1,IF(B18>=4,"-",$B$1*(1-VLOOKUP(B18,$D$4:$E$7,2,0))))
C19=IF(B19=0,$B$1,IF(B19>=4,"-",$B$1*(1-VLOOKUP(B19,$D$4:$E$7,2,0))))
C20=IF(B20=0,$B$1,IF(B20>=4,"-",$B$1*(1-VLOOKUP(B20,$D$4:$E$7,2,0))))
C21=IF(B21=0,$B$1,IF(B21>=4,"-",$B$1*(1-VLOOKUP(B21,$D$4:$E$7,2,0))))
 
Upvote 0
as always, this is greatly appreciated michael m. i could do the simple formulas (i.e., rows 4-8) & pretty much what you shared is the same as what i've done for the said rows. the crucial parts are those in c12:c21.
just a quick 1: i tried having whole number + decimal for instance 1.5, 2.1, etc. as entries in leave(s) column (b12:b21), but results were: #N/As. what is the remedy for this? thank you.
 
Upvote 0
Basically the new formula in "C" will eliminate ALL #N/A's
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Formula Filled Dates
Replies
4
Views
334
Fluff
Fluff
M
  • Question
HELP IDENTIFY ORIGINAL START DATE BASED ON CONTINOUS SERVICE RULES
Replies
0
Views
352
mrshuck
M
B
  • Question
dynamic formula help - supply multiple variables and process row by row
Replies
0
Views
383
BrettJH
B
R
  • Question
Calculating Man Hours Worked on Day Night Shift
Replies
0
Views
2K
richy89
R
P
  • Question
Vacation Time Allocation
Replies
0
Views
249
polska2180
P

Forum statistics

Threads
1,215,025
Messages
6,122,734
Members
449,094
Latest member
dsharae57

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top