vac

I will try and explain this as best as possible. Cell A1 has a starting balance that represents vacation time remaining. Let's assume that balance is 40.0. Cell B1 has a drop down (VAC 4.0, VAC 8.0). I want cell A1 to update with the remaining balance. If the user selects VAC 4.0, cell A1 should...

Hey all, I am new to the forum I am absolutely stuck and would like to see if I can get some assistance. I have been working on my schedule program for awhile now and actually have a completed schedule but would like to make some much needed tweaks to make it even better. I’d like to add a...

Hi ~ Need a bit of help. I have a spreadsheet where I am trying to incorporate an accrual usage calendar with columns that will calculate the usage based upon what is accrual is typed in a particular day of the month (cell). I have this so far ... =IF(OR(J7="VAC", L7="VAC"...

Hello, I am attempting to build a formula that displays the status of employees on a calendar. I am trying to get the "Value If True" portion of the formula to change based on the status selected. So, if Vacation is selected, then "Vac" is displayed. If "Sick" is selected, then "Vac" changes...

I am trying to enter formula's on this bi-weekly time sheet that will only calculated regulars hours up to 40, and OT for all hours over 40. I can get it close, but just can't get it to work correctly. I'm hoping you all can help. Thanks...