Search results

It will be pulled out of timekeeping and copy and pasted in excel form. Basically a running tally and when the 6 month date comes up then a point is taken off employee. exp. point on January 1st and 6 months later point is taken off to keep track of employees points.

I am looking to put together an excel sheet to track attendance points throughout the year as a rolling 6 months. Simply excel sheet with Name in column A and Points in column G with Date in column F. Information will continue to be added to sheet. Can someone help me out?

I have below formula in which I believe it will take a point of after 181 days. So basically if someone got a point on January 2nd the point should come off July 3rd correct? I don't see the points coming off. Can anyone help...

Sorry for the file not working right. I understand the hyperlink section and have had it work many times. This time it is coming up with an error "No program is registered to open this file". I right click and click on hyperlink then use drop down box to go to file I want hyper linked to cell...

I am trying to create a hyperlink between Test file and Bulk file. In Test file, PO # section is where I want the hyperlink to link to Bulk pick bins.xlsx file. Basically want to open up test file and click on PO # and the appropriate bulk pick bins excel file opens up with information. Thank you

=MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())) I have the following formula in F2 cell. I would like to have this cell to show blank instead of zero.

Basically looking for a formula/command when email hits 4 points an e-mail will automatically be sent to the supervisor.

How do you insert an automatic email command in excel? Need to have an automatic email sent to supervisor if say 4 total points are hit with information. I am in the process of creating a form to be sent but need to know how I set his up and then when form is completed, how to attach to auto...

Luke, I am attaching another excel file. It doesn't seem like the formula is working. As you can see in total points column people are showing points but in Points sub column with your formula it shows 0. I would like Points Sub column show total points and then when 6 months which equals about...

I attached a new version. Yes there will be multiple people in file listed in Jane Doe area. It will be a daily upload inputted for previous day. I am trying to figure out if Jane Doe 1 gets a 1 point on Jan 1st need report and July 1st comes along need the point to go away it is past the 6...

Hi! I am looking to find out how to create a formula that will do a rolling 6 month point structure. Basically total point that can be accumulated in 6 months is 7. I want to have it take a point off when the 6 months is up. The point structure will be 1 thru 7 . It can be half points in there...

SELECT Tasks.* FROM Tasks WHERE (((Int([Due Date]))=Int(Date()))); Here is the logic. How would like to have this show information for 7days from due date?

The drop down box is used for the bottom section. When you click on drop down box you can pick any month, which will bring up that month's information from other tabs into one. I would like to be able to bring up any month's information from drop down box and it will fill the top part for...

I have a summary page with set up with Months listed on top and groups listed on left side. Below I have a drop down box which brings up each months information. I would like to be able to bring up January and have the information populate in summary section for January in upper section of...

When I add an amount in E7 is &#60;0 the formula works. Once I add an amount in E7 it changes to false. Can someone tell me why

The formula worked thank you

When I implement the formula into spreadsheet it comes up as false instead of number.

=IF(E7&#62;0,SUM(E38+E18-E33),IF(E7,D38&#60;0,SUM(D39+E18-E33),IF(D38&#62;0,SUM(D38+E18-E33,0))) The above formula seems to not want to work. It tells me to many arguments but I am not sure why. If cell E7 is &#62;0 sum E38+E18-E33 If cell E7 and D38 is &#60;0 sum D39+E18-E33 If cell D38...

You are correct. thank you. over think sometimes...

correct, I do I get it to calculate the negative numbers has well?

Yes, it is to calculate to a percent.

I have the following formula =IF(C46&#62;0,SUM(C45-C46)/C45,0) It works fine until I get across to cell I46 which is a negative number and comes up with 0.00%. How do I fix this one?

I have the below formula in worksheet. It works when there is information in C7 greater than 0.When I move across and C7 is less than 0 then it gives me false. What am I missing? =IF(C7&#62;0,SUM(C38+C18-C33-C29),IF(C7&#60;0,SUM(C18-C33-C29)))

Thank you both this helped... St Patty's day around the corner Ha Ha Ha

I am having a brain freeze. What formula can I use to subtract positive and negative numbers. Example base # 8,000,000 - the following numbers below in cells. The issue is when I get to the last two calculations ( which are negative numbers), it is adding them instead of subtracting. My goal...