 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006Excel 2003- Benefit attandance calendar
I have downloaded this template from the website & have done some revamping to fit our needs. The letter codes in this template stand for different things (of course) & each letter figures as one point. I need two of these letters to figure as 1/2 point. Is there a way to do this? What do you mean by 1/2 point? > I have downloaded this template from the website & have done some revamping > to fit our needs. The letter codes in this template stand for different > things (of course) & each letter figures as one point. I need two of these > letters to figure as 1/2 point. Is there a way to do this? Since it is an attendance form for employees we are figuring an unexcused absence as "1" point so if I enter "U" which means "Unexcused" then the form figures it as 1 point. But I need it to figure if I put a "G" in the cell it reads it as 1/2 point (or .5) not "1". I hope this explained it better. There is only 2 letters that need to figure as .5 the rest is fine as "1". > What do you mean by 1/2 point? > > > I have downloaded this template from the website & have done some revamping > > to fit our needs. The letter codes in this template stand for different > > things (of course) & each letter figures as one point. I need two of these > > letters to figure as 1/2 point. Is there a way to do this? Format the cells that need to show .5 as decimals. It sounds like your cells are fomatted to round up to the whole digit. > Since it is an attendance form for employees we are figuring an unexcused > absence as "1" point so if I enter "U" which means "Unexcused" then the form [quoted text clipped - 8 lines] > > > things (of course) & each letter figures as one point. I need two of these > > > letters to figure as 1/2 point. Is there a way to do this? I have tried that, but it don't work. You see all I enter in the cell is a letter like "L" & the system automatically figures it as "1", but there isn't any formula in the cell you put the letter in just a drop down list showing the letter allowed to be put into the cells. I can't even manually put in ".5" it won't except it so that tells me when they set up the form at Microsoft they validated these cells & I don't have a clue how to fix it to read as .5. > Format the cells that need to show .5 as decimals. It sounds like your cells > are fomatted to round up to the whole digit. [quoted text clipped - 11 lines] > > > > things (of course) & each letter figures as one point. I need two of these > > > > letters to figure as 1/2 point. Is there a way to do this? Sounds like a data validation issue then. Select the cell in question, go to Data-->Validation and see if there is a restriction on the type of data that can be put in the cell (i.e., text, a list, a number, etc.) Clear whatever validation there is and see if you can enter .5 then. Dave > I have tried that, but it don't work. You see all I enter in the cell is a > letter like "L" & the system automatically figures it as "1", but there isn't [quoted text clipped - 19 lines] > > > > > things (of course) & each letter figures as one point. I need two of these > > > > > letters to figure as 1/2 point. Is there a way to do this? Please provide a URL to the template in question so we may download to look at it with an eye to assisting you. Gord Dibben MS Excel MVP >I have downloaded this template from the website & have done some revamping >to fit our needs. The letter codes in this template stand for different >things (of course) & each letter figures as one point. I need two of these >letters to figure as 1/2 point. Is there a way to do this? It is in the Microsoft website under templates "Attendance calendar" is the name of the file for excel. Hope you can find it & help me. It is about to drive me NUTS!!! > Please provide a URL to the template in question so we may download to look at > it with an eye to assisting you. [quoted text clipped - 5 lines] > >things (of course) & each letter figures as one point. I need two of these > >letters to figure as 1/2 point. Is there a way to do this? And what prevented you from finding it at that site and posting the URL? There are several Attendance Templates at that site. I will take a guess at the one you are using. From G119:R130 is a series of =COUNTIF formulas Change G119 to =COUNTIF(January,$B119)/2 Drag/copy this across and down to R130 Gord Dibben MS Excel MVP >It is in the Microsoft website under templates "Attendance calendar" is the >name of the file for excel. Hope you can find it & help me. It is about to [quoted text clipped - 9 lines] >> >things (of course) & each letter figures as one point. I need two of these >> >letters to figure as 1/2 point. Is there a way to do this? That just may work. I didn't copy the URL because I would have had to get out of the discussion to get to it & then back in to answer you. I thought just telling you the area & name of it that you could find it & I was right you got the correct one. Thank you! I will try it & let you know if it worked or not. > And what prevented you from finding it at that site and posting the URL? > [quoted text clipped - 23 lines] > >> >things (of course) & each letter figures as one point. I need two of these > >> >letters to figure as 1/2 point. Is there a way to do this? IT WORKED, THANK YOU SO MUCH!!! > That just may work. I didn't copy the URL because I would have had to get > out of the discussion to get to it & then back in to answer you. I thought [quoted text clipped - 29 lines] > > >> >things (of course) & each letter figures as one point. I need two of these > > >> >letters to figure as 1/2 point. Is there a way to do this? Glad to hear. Gord >IT WORKED, THANK YOU SO MUCH!!! > [quoted text clipped - 31 lines] >> > >> >things (of course) & each letter figures as one point. I need two of these >> > >> >letters to figure as 1/2 point. Is there a way to do this? Gord Dibben MS Excel MVP BTW Info only. If you used a real news reader instead of the Windows CDO to access these groups, you would not have to leave your reader to go to a website. Outlook Express comes with Windows OS I use Agent and would not change. Gord > I didn't copy the URL because I would have had to get >out of the discussion to get to it & then back in to answer you Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.