How do I use an IF formula that displays PASSING if the average of the project grades is at or above 36 points and UNSATISFACTORY if that is not the case? if each score is in cells A1 to A4 then use =IF(AVERAGE(A1:A4)>=36,"PASSING ","UNSATISFACTORY ") -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Fahim" wrote: > How do I use an IF formula that displays PASSING if the average of the > project grades is at or above 36 points and UNSATIS...

Dear All, apologies if this is probably a mundane question, but I didn't know what 'search terms' to put in google to return any results.. I've got a Spreadsheet with 12 tabs (sheets), I need part of tab 12 (sheet) to appear on tabs 1-11 (sheets), so that if I change data in tab 12 (sheet), tabs 1-11 (sheets) are changed too.. the cells themselves will never move location, just the data within them.. Is it possible? Regards Paul. On your sheet1 select the cell that should receive the data from Sheet12; Hold down the Shift key and Click on Sheet11 << this shoul...

Im trying to create a chart in Excel based on the reult of a column or formula's I wrote. The chart just seems to show the formula as its values, can anyone help? I had a list of employee ages and used a formula to indicate their age bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that will show how many employee's are in each bracket. Help is much appreciated asap as its for my job. Thanks in advance. -- Boba Fett ------------------------------------------------------------------------ Boba Fett's Profile: http://www.excelforum.com/member.php?action=getinfo...

Is there an easy way to copy this to about 700 cells? =SUMPRODUCT((A4:A11998=S6)*(B4:B11998=V3)) there has to be an easier way to copy this. Easier than what? Copy and paste? Or drag to fill? If you want exactly the same in all 700 cells, make the cell references in the formula absolute & it will copy without change. [But why would you want to do that?] If you want any or all of the references to change as the rows or copies change, make the relevant parts relative addresses. -- David Biddulph "tim2216" <tim2216@discussions.microsoft.com> wrote in message new...

Little bit of a quirky question... Trying to use a cell value as a reference in a formula, where that cell value is the name of a named range. So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2. I want to get the correlation vale for A1:A3 and B1:B3 So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the formula: =correl(D1,D2). But I get an error. Have also tried using Indirect to no avail. Any help would be hugely appreciated. Thank you. =CORREL(INDIRECT(D1),INDIRECT(D2)) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "ste...

I just upgraded to office 2003. When I get a lower version file from someone, and I do a copy and paste, it copies the exact same formula with the $ sign which I cannot see where to get rid of. The calculation box is set to automatic, not manual. How do I resolve this? I didn't have that problem before. Thanks. Hi this has nothing to do with the Excel version. In this case the formulas was entered with absolute references (the $ signs). If you want the references to change you have to delete these $ signs. Either manually or clicking on the reference and hitting F4 to toggl...

i was wondering if i had posted this in the right section as it could apply to both please could you take a look at the following post http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/f088a5737dd26570 thank you Is there some reason you can't post your question here instead of asking us to look elsewhere? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Blinds Nottingham" <bradrail.blinds.awnings@googlemail.com> wrote in message news:d8768e43-e035-45eb-856a-0ccdc843441d@g1g2000yqi.googlegroup...

Folks: (IF(ISERROR(MATCH(B1,A:A,0)),"No Match","Match") Column A Column B Column C 25 50 No Match 30 30 Match 26 28 No Match 55 60 I am using the above formula to compare two columns (A and B) for overlapping (common) data then put the result ("Match" OR "No Match") in a third column. So far this formula has work...

We did an inventory adjustment and now we get a unknown amount in Debit under the Inventory account and Credit for COGS account in the Transaction Entry Zoom. We're trying to figure out where that amount came from but we couldn't zoom more than what it's currently shown. In both fields, Reference and Distribution Reference, it's shown IVA#######... that is unknown to or setup by us in anywhere, i.e. Audit Trail, Source Document. Does this amount affect the dollar in the accounts mentioned? And can anyone please help to where we could drill down the IVA details?...

I have a worksheet that contains the daily purchases for 4 products. column B contains the products column D contains the purchase price column K contains the division column J contains the day of the month I need a formula that will pull the latest purchase price by product by division. In other words the last purchase for the month and the associated purchase price. Thanks -- col You can do that with this array* formula: -- Best Regards, Luke M "Curtis" <curtis.eadie@yahoo.ca.(do not spam)> wrote in message news:61160B81-7277-4C97-8...

i am working on excel and the book asks that i enter data s=using formulas for specifically the last three years of what i am referencing to. and i have to know how to us the copy command button. can anyone help ...

I have been given a task to collect info and create several spreadsheets but I have one more formula to create. Here is it... The formula has to callers receiving points for the amount of Western Union sales they have for the month. Let say the entire department AVERAGE (this number will change every month) was 161 sales; then 161 would be the median. If the caller had 171 - 180 sales then he or she gets +1 point. If the caller had 181 - 190 sales the caller gets 2 points, etc.. until the mark of 321-330 in which they get 16 points. So, if I enter the number 255 in the cell then the an...

I am having difficulty writing a formula to sum two different types of data in single formula. I know how to use an "if" statement to create another two columns and add this way, but I would like to use a vlookup, maybe?, or something to total. Below is a simplified version of what I am trying to get two different sums for. I need a total of "DIV"s and a total of "AP"s as well. Thank you for any assistance. Type Amount AP $1,050,100 AP $249,500 AP ...

Hi, When I create a macro in Excel, and assign a button to it, it works fine the first time, but when I re-open the workbook for a second time, and try to run the macro again, the macro seems to refer to the previous workbook...For some reason, the macro saves the name of the previous workbook... Sub test() ' Dim name As String Dim adress As String Sheets("sheet1").Select Range("A1").Select name = ActiveSheet.Range("B6").Value adress = ActiveSheet.Range("B4").Value ActiveWorkbook.SaveAs Filename:="C:\WINDOWS\Desktop\Temp...

I am trying to write a formula that works off what is in two separate cells. It has several parts and maybe not all of them can be done. It would be great if someone could help me out. Here goes. If A2 & A3 each have a "N" in it then I want cell A5 to show today's date plus 20 weeks. However, if only 1 of the cells A2 or A3 has a "N" in I still want A5 to show today's date plus 20 weeks. Can this also be done? If both A2 & A3 have "Y" in them then I want A5 to freeze with the date last show when 1 of the two cells had a "N" it ...

Greetings, I have a cell formula that is damaged each time I run a delete to remove excess rows before a paste & copy. this formula links to a cell that is always deleted. So I am trying to repair this formula at the end of each cycle. Here is the correct formula: =IF(A11="Proximates","Click","") Here is the same formula after the delete: =IF(#REF!="Proximates","Click","") I tried to fix this in the code that does the finale copy & paste with this: Range("B2").Formula = "=IF(A11=...

I am trying to raise a formula that gives me a sum of two cells when there is a positive value present and the following appears to satisfy this. =IF(H55<>"",H55+H56,"") The problem is that if the cell H55 is actually empty, I want to sum two different cells in this case H54+H56. Is there any way of achieving this with the OR or some other function? I received some very helpful replies to this enquiry 30th June 2004 but.............. I am getting there :-) Every one of the suggestions worked but only when I deleted the content of cell H55. Cell H55 actually ...

How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references Dave Tools>Options>View. Uncheck "row and column headers". Good idea to spend a few minutes browsing through the various Tools>Options tabs to see what else is available to toggle on/off. Gord Dibben Excel MVP On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com> wrote: >How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top an...

i am trying to make a formula that says "if text in cell A1 is "apple" then add number in cell A3 to cell A2" If Text in cell A1 is Orange then add number in cell A3 to Cell A2 That looks like the same action to me. Where does the result go? If you want it in A2, you need code. -- HTH RP (remove nothere from the email address if mailing direct) "detlghtpd" <detlghtpd@discussions.microsoft.com> wrote in message news:1B8CC41B-D613-41A1-841A-586F4CE137E4@microsoft.com... > i am trying to make a formula that says "if text in cell A1 is "...

Formula in C3 is =IF(E3>D3/12,E3,D3/12). I would like to have the cell (d3 or e3) where the data entered last control the answer in c3. -- Val Put this in C3 instead..... =IF(COUNT(D3:E3)=2,IF(E3>D3/12,E3,D3/12),"") Vaya con Dios, Chuck, CABGx3 "Val" <Val@discussions.microsoft.com> wrote in message news:DEC352A2-AF08-4796-BF77-E5C1F3F02E3A@microsoft.com... > Formula in C3 is =IF(E3>D3/12,E3,D3/12). > > I would like to have the cell (d3 or e3) where the data entered last control > the answer in c3. > -- > Val ...

I had a problem today with a missing reference - Microsoft Forms 2 on a colleague's machine at work (Office 2003; VBA 6.5; XP). I've read Chip Pearson's "Missing References in VBA" which is a geat explanation about how to fix problems like this. Oddly the library didn't seem to be flagged as "missing" and was in fact present in the system32 directory but didn't show up in the list of available references. Now to the questions: I'm not clear on whether if I write code in a project that references a library which is not part of the &qu...

Is it possible to create a reference to another object such as: int & x = i; but using an image list, and referencing different objects depending on a condition? such as : CImageList & imageList; if (thumbnail == 1) imageList = m_ImageListThumb; else imageList = m_ImageListFullSize; Hope this makes sense! Ben You're better off using pointers for this. I believe, depending on the class, that what you're trying to will make a copy of the object instead of referencing it. "Ben Williamson" <oakdaleclose@googlemail.com> wrote in message news:43ee4603...

when I enter a formula in a cell it displays a 0, when there is not an answer to the formula. Is there a way to keep the formula but get rid of the zeros any help is greatly apperciated! Thanks, Darrell Two ways, In Tools>Options>View, uncheck the zero values checkbox - that hides them Other way is to trap it, like =IF(formula=0,"",formula) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Darrell" <anonymous@discussions.microsoft.com> wrote in message news:D4B48DFF-...

A co worker is taking an Economics class and has an Excel formula tha calculates raising interest rates. The formula provided is (1+r)^t is represntative of column A. She is unsure what ^ is suppsed to mea or do concerning this formula? Any thoughts and answers are greatl appreciated. Thanks Ja -- Message posted from http://www.ExcelForum.com The ^ (caret) is an arithmetic operator which stands for "Exponentiation" (to the power of) Example: 3^2 is the same as 3*3 -- Rgds Max xl 97 -- Please respond, in newsgroup xdemechanik <at>yahoo<dot>com --- "Jay Hanks >...

Hi, I'd like to automate the following procedure using a macro. Please help. 1) i have 2 sheets: Sheet1 & Sheet2 2) In Sheet1, Cells B2,D2,F2 has the formulas "=Sheet2! F2", "=Sheet2!K2", "=Sheet2!P2" correspondingly. 3) Every month when i do my work, i'd have to manually rekey the formulas to reference the subsequent columns, ie, Cell B2,D2,F2 will change from above to "=Sheet2! G2", "=Sheet2!L2", "=Sheet2!Q2" and in the following month, I have to change manually again to "=Sheet2! H2", "=Sheet2!M2&qu...