leave

I am trying to return a value based on a cells contents but also based on certain conditions and I cannot work out how to run two IF statements in a single formula If Cell A1 contains "Cat" return a value of "Y" else leave blank, this I can do with =if(A1="Cat","Y","") but I need to append...

Hi all, I've set up a leave calendar where we add the staff requests row by row. To the right of this there is column for each day of the year. In each of these cells there is a calculation to work out if that day for that person is a true holiday (populates the cell with data from another...

Hi All I have a simple module assigned to a button that hides 5 rows and I also have a split widow. So when I am in row 300 or so and I use the macro, it selects cell A10 and scrolls to the top of the window. I know that I can tell what cell to be selected in the code. Is there a way to leave me...

Similar to a table where it highlights every other row, I need to highlight two rows, then leave two blank and then highlight two etc - for the whole sheet. Any ideas?

<tbody> Month Emp # Opening Casual Leave Availed Casual Leave Casual Leave Balance Sep 18 1 05 01 04 =(C1-D1) Sep 18 2 07 02 05 =(C2-D2) Oct 18 1 04 ? auto fill Oct 18 2 05 ? auto fill </tbody> how to opening casual leave auto fill while entering new month payroll?

I need to auto populate another sheet, when a button is clicked to do the following please Main data is on a sheet called "Master" Data needs to populate on sheet called "Priority" If there is data on the "Master" sheet in column AC (from Row 3 downwards to row 500) I want the following to...

Hi all, I am trying to work out a formula that will do a calculation OR don't and leave blank if there is a zero or a blank cell. Thanks in advance. Example: <tbody> A B C (expected result of formula) 1 10 =A1 10 2 18 IF in A2 there is a number that it is not '0' or blank, leave this...

The below example is an employee who has a previous balance ofleave. If that employee takes time off from work then that time is subtractedfrom his leave. Therefore, used hrs would be deducted from his balance. In the below scenario the employee had 23 days 6 hours and 45 minutes of leave...

I'm trying to write this: =IF(O3<0.89,25,IF(O3>0.949999,0,15)) It works, although, I want to also add, if cell has text or text n/a, tbd, or blank then leave blank

I have a worksheet that tracks leave taken. Cells in the range D4:Q29 fill with RGB,251,191,143, when it is <today. The range covers a 2 week pay period, therefor a 26 pay period year. I am trying to write a formula that counts the number of days till the last day in the last pay period, minus...

Formula for this: If column C= "Y" then amend column A "ABCDE" but what if column ="N" then i want to leave column A with value already contained in that cell

Hi Friends Thanks to all of you for always helping me. Here, I need an advice from you. I have an excel workbook which has multiple sheets linked to each other with formulas and macros. I want to share this workbook with my team for their use when they are on duty, but I want to secure this...

Hi- This is probably easy for the experienced folks here. I am simply wanting to calculate the number of nonblank cells (numerical) between columns F2:BF2 and want to leave the new cell blank if all of the cells in that range are blank. Any suggestions? Thank you! OS

Help with formula subtract dates =CA-BG gives me total days but if CA is blank How can I leave the cell CA blank?

Hi; I am tasked to replicate this module I have posted in another application, and have run into some issues in doing so. Forgive my need to ask an obvious question to some who are more versed in VBA, but in examining the posted module below, I am trying to verify that I am capturing the right...

Hi, Hope you can assist me. I have workbook for leave application. I used userform for the data entry which I already sorted out through help of great people here too. However, my concern now - if I want to click a command button "Update", I want the data entry from "Sheet 4" to populate in...

Hi All, Below is the data of the staff who has taken leave on the below dates. I need a formula which can cull out month wise , staff wise leave taken. Data <colgroup><col><col><col></colgroup><tbody> Date Staff Leave taken 03-Apr-18 AA 1 06-Apr-18 BB 1 18-Apr-18 EE 1 06-Apr-18 BB 1...

Hi, I've been looking on this for a while and can't seem to figure it out. I've fried looking for a solution on the internet, but it won't help. So, in column E I want to sum up all amounts in C until a blank cell is reached. So for cell E3 I want to sum up 195,97 and for cell E8 I want to sum...

I am trying to determine the number of people (List of Employees) on vacation based on their vacation start date and end date (Employee Leave Tracker). I need to account for each day of the year and ensure a certian percentage is not absent. I have tried: =COUNTIFS('Employee Leave...

Hi, I am trying to track my Retail Employees via Excel. They submitted their responses via Google Form which have various Leave Types like Annual Leave, Medical Leave and etc. Form Response 1 is their responses, but I am trying to do a LookUp Table to add on their leaves for the entire period...