As I understand it, the gift receipt replace the current receeipt. It need to be a option under the function keys, that will allow you to print the original receipt for the customer, then print a gift receipt if requested. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message p...

If the value of a cell is a letter, can this be used in an IF formula? I am making a simple chore spreadsheet for my kids. In this sheet, each chore is represented by a letter. (i.e. B=clean bedroom) Also, each chore has a certain value amount with it (i.e. B=$1). I would like to be able to have the kids enter in the chore letter when it's completed and have the computer do all the calculations of amounts and totals. Can this be done? For example: =IF(c7=B,1,IF(c7=K,2)) ...

My sheet has cells whose values are determined by the result of an IF formula, eg =IF(LEFT(F20,3)=I$5,$G20,0) I want to have a total of each colum but when I insert a SUM formula it gives a 0 result. I thought it might be something to do with the calculation order but I don't know how to change this. Any ideas how I can get this to work? Thanks, Seamus Seamus, Your 'LEFT(F20,3)' function is returning a text string. If you replace it with 'VALUE(LEFT(F20,3))', the text string will be converted to a numerical value. If you are using Excel 2003, try the Tools\Form...

I think the following idea can be accomplished using Excel's Data Interchange Format. A. I have three retail stores with standalone POS systems. I can pull reports from each system. I want to consolidate these reports at the headquarters level. B. Each store can export the report in a DIF format. C. Each report contains sales for departments. Each department has a unique department number. Each store has a unique store number, though not on the report. Question: What would be the broad steps involved in combining the data into one report at headquarters level? I think I recall...

After reviewing some previous posts, I've come up with the following function. Ideally, I would like to give it a Name reference, but it is too long. Any suggestions for simplifying and shortening? The formula looks at the left adjacent cell for location codes that correspond to location descriptions. The column locations have the potential of changing so I needed a solution that could dynamically change without a fixed reference point. Let me know if you need any other information. Thank you in advance for any assistance. =IF(INDIRECT(ADDRESS(ROW(),COLUMN()-1))=&quo...

Thanks in advance for any help. I'm trying to create If DCount code on my form that will count the number of duplicate records and then notify me when the number of duplicate records exceeds the number allowed. The number of duplicates allowed is established in tblFloorProgCriteria in the field FloorProgMaxObservations. Here's what I have so far...It's giving me the message as soon as I attempt to add the first record. If DCount("*", "tblFloorProgAudit", "[AuditID] = " & Me.[AuditID] & " And [FloorProgCriteriaID] = ...

Hi. I use this formula: =COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40) I would like to modify it so that the value I put in Cell A1 (eg 100) will change the formula to this: =COUNTIF(I5:I100;TRUE)/COUNTA(I5:I100) Thank you in advance. Check the INDIRECT() function in HELP -- Kind regards, Niek Otten Microsoft MVP - Excel "carl" <carl@discussions.microsoft.com> wrote in message news:635DC7A7-0B24-4C8C-8317-D9FA59DAE124@microsoft.com... > Hi. > > I use this formula: > > =COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40) > > I would like to...

Hi, I am trying to make a calculation that will take Pass/Fail values of P or F and give me an overall value of P or F. There is also an issue if a value is Not Tested, NT. For example, I have three levels of requirements (parent, child, and grandchild). Parent is level 1, Child is level 2, and Grandchild is level 3. For each grandchild requirement multiple tests can be completed with a P, F, or NT result. I have come up with a formula that will give me an overall result of P or F: =IF(COUNTIF(H8:H9,"F")>0,"F","P") to say If any value i...

Hi There, I have rows of text strings in Column A and in Column B. I need rows in Column A removed if they partially or exactly match with text strings in any Column B row. Your input is appreciated! Alexa You may get better, er, some responses if you describe what "partially match" means. registrations@discountcosmeticsguide.com wrote: > > Hi There, > > I have rows of text strings in Column A and in Column B. > > I need rows in Column A removed if they partially or exactly > match with text strings in any Column B row. > > Your input is appreci...

Hi A cell (H6) in my spreadhseet currently contains the following formula: =IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6)) If the value returned is >1 then i want the font in the cell to turn red. Please help. Thanks Dan If you are using Excel 2007 you can use conditional formatting. It should show up on the "Home" banner. If you're not in 2007, not sure that it can be done. "housinglad" wrote: > Hi > > A cell (H6) in my spreadhseet currently contains the following formula: > > =IF(ISBLANK(G6),"",NETWO...

How do i link an employee to their wage automatically? Is it possible to enter in my employee's name and hours, and have it automatically calculate their wage? I have all my employees wages in another worksheet right now. At this time I go to my job record worksheet I enter in my employee, enter the hours type =left arrow tab to worksheet with wages and click on the employee then hit enter, this gives me there total wage. I am trying to see if I can program the name and wage together somehow, that when I do type the name it calculates with the hours and gives me a total. tb Use ...

I have the following formula to calculate some numeric data: =SUMIF(F6:F27,F5,S6:S27) (this is in cell S5) the qualifying code is in column F and the numeric data to sum is in column S Problem. When I insert a row just below row 5, the formula in S5 changes to: =SUMIF(F7:F27,F5,S7:S27) I will be adding data to the new row6 and I need it to become a part of the calculation. I need the formula to remain F6: and S6: How can I do that? Glen One way =SUMIF(INDIRECT("F6:F27"),F5,INDIRECT("S6:S27")) -- Regards, Peo Sjoblom "Glen Mettler" <glen.e.m...

PLEASE PLEASE, can someone help me. I posted this on Nov. 6 and last week. I am having to do a "repair" EVERYDAY to get my sounds back for when I get a new email , contacts sign -on etc. All my other programs have sound so I know that it is just in the messenger. When I am done using the messenger I sign out and then the next time I sign in I have to do the repair. THIS IS VERY ANNOYING TO HAVE TO DO EVERYDAY!!! I have used the tool to do a clean uninstall and have installed and reinstalled several times. Vista Home Premium sp2 NIS 2010 worked with 8.5 IE...

I have a column that contains three text descriptions ie. Intermediate Average or Advance. Using the CountIf function , I am able to count each description separately and then show the overall total. Can I modify the Countif to add up the three descriptions and display a single total of their occurance? Thanks very much One way: =SUMPRODUCT(COUNTIF(A:A,{"Intermediate","Advance","Average"})) In article <06f001c48c09$d156fdb0$a401280a@phx.gbl>, "Deltaecho" <anonymous@discussions.microsoft.com> wrote: > I have a column that conta...

I have a table full of items, below is one example from the table. I am trying to do a query that will display the longest dimension (as L1) for each item. Item field is text, all others are numbers. Here is my data: Item = Y10227 ItemLength = 8.375 ItemWidth = 9.25 ItemHeight = 5.125 Here is the field in my query to determine the largest of the dimensions: L1: IIf([ItemLength]>[ItemHeight] And [ItemWidth],[ItemLength],IIf([ItemHeight]>[ItemLength] And [ItemWidth],[ItemHeight],IIf([Itemwidth]>[itemheight] And [itemlength],[itemwidth]))) The result I am gettin...

Can any one offer any assistance with the following query. See example table in a worksheet; Column A B C D E F Seq Month C/C A/C Ac name Actual � 1 Jun 04 7313 30613 Training(NR) �2,250 2 Jun 04 7323 60301 Plant Hire �5,500 3 Jul 04 7324 30810 Prot clthng �1,500 4 Aug 04 7313 30612 Training (R) �6,500 ETC.... NOTES: -The data at the moment extends to 600 line items for one mont therefore potentially could be circa 7,500 line items -I dont want to use pivot tables as this is to be template to issue to other users with little or no...

Thanks in advance for any help offered. I have a table with GPA's and need to calculate the different ranges. I have the function for 3.0 an above and less than 2.5. I am having trouble figuring out the formul to count how many students are in the range of 2.50-2.99. I thought I could do this: =countif(f2:f406, ">=2.5+<=2.99") I get "0" as a result. any help is appreciated : -- Message posted from http://www.ExcelForum.com Hi, You can use Sumproduct... =SUMPRODUCT(--(F2:F406>=2.5),--(F2:F406<=2.99)) Hope this helps -- Message posted from h...

Hi, I'm sure its a very obvious mistake I've made, but this is the firs time I've attempted to use Excel. I am typing in the following formula to find a percentage of a numbe of values, but to ignore any values that are zero or less. The value are changeable so it is vital that all cells that could be filled ar considered. I used the COUNTIF function so only values greater tha zero are considered. This is what i entered:- > =SUM((F8,I8,L8,O8,R8,U8,X8,AA8)/800%)/COUNTIF(F8,I8,L8,O8,R8,U8,X8,AA8,">0") It doesn't look right...i've tried without some bracke...

I want to create a formula in a spreadsheet that refers to specific cells of data. However, I also want to be able to sort my data but keep the formula refering to the same information. IE, say I have a collumn of ten numbers. I would like to be able to have a formula take the average of the first 5 listed. If I then did a sort function of these ten numbers that changes the order of the numbers, I want my formula to have the same result because it is still referencing the correct information. ...

i AM WORKING ON A STAFF SCHEDULE. TIMES ARE ENTER BY A FORMULA. I WOULD LIKE TO HIGHLIGHT CERTAIN FORMULAS TO COME UP IN A SPECIFC COLOR. It is considered VERY rude to shout by typing in all CAPS. It's also harder to read. Use format>conditional format>formula is> -- Don Guillett SalesAid Software donaldb@281.com "TEDDY" <TEDDY@discussions.microsoft.com> wrote in message news:4550FF41-498B-48A2-AB5C-10791F2D30E0@microsoft.com... > i AM WORKING ON A STAFF SCHEDULE. TIMES ARE ENTER BY A FORMULA. I WOULD LIKE > TO HIGHLIGHT CERTAIN FORMULAS TO COME UP IN A S...

I am getting an error messge saying a I am missing a ( or|and I can not figure out what is wrong. Can you please assist with debugging the following code: Test: IIF(Month(Date())>10 AND Month([Contract Info].[Start Date])<3, Year(Date())+1, Year(Date()) Essentially I want this calculated field to take a look at the current month and for January and February add one the the current year, otherwise the field should be the current year you are missing a parenthesis at the very end. that last parenthesis you have is ending only the Year function, but you also n...

I have a question regarding Nested If statements in Excel 2003. I have a commission structure below that needs to be nested 0-$50K = 10% 50-100K = 20% 100-150K = 25% 150-200K = 30% 200K+ - 35% For example: Fee commission rate commission 19,125 10% 1,912.50 8,000 10% 800.00 8,000 10% 800.00 8,000 10% 800.00 Total Billings: 43,125 Here is where I am running into a problem. At this ...

Dear sir, I have a problem regarding the SUMPRODUCT function. I used to add some numbers from number of worksheets such as WK1, WK2, WK3 etc. As a result, my formula become very long as following: =SUMPRODUCT((WK1!$E$2:$E$100=$D8)*(G$3<WK1!$B$2:$B$100)*(WK1!$B$2:$B$100<=H$3) ,(WK1!$D$2:$D$100))+SUMPRODUCT((WK2!$E$2:$E$100=$D8)*(G$3<WK2!$B$2:$B$100)* (WK2!$B$2:$B$100<=H$3),(WK2!$D$2:$D$100))+SUMPRODUCT((WK3!$E$23:$E$100=$D8)* (G$3<WK3!$B$2:$B$100)*(WK3!$B$2:$B$100<=H$3),(WK3!$D$2:$D$100)) My question is that is there any way to have one formula which can perform the same fu...

Hello I have a macro which I've been using for quite some time. This macro allows the user to identify the User IDs of people listed in the spreadsheet. However, I now need a macro to do the reverse. That is, it needs to find the names of people whose User IDs are listed in the spreadsheet. If possible, it would be great to list the given name and surname in separate columns, although I could do this separately via another macro. Is it possible to modify the existing code below to achieve what I want (i.e. so that it does the reverse of what it currently does)? I...

I'm making a DLL which has a routine that opens a file, allocates memory, does stuff, deallocates the memory, and closes the file before returning. My question is what happens if the process gets deleted while it's in the middle of that routine? Does the open file automatically get closed? Does the allocated memory automatically get deallocated? Or do I have to put cleanup code in the case DLL_PROCESS_DETACH:? BOOL WINAPI DllMain( HINSTANCE hinstDLL, // handle to DLL module DWORD fdwReason, // reason for calling function LPVOID lpReserved ) // reserved { sw...