formula wording

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - how can I compare spread sheets? This does not solve it :( My data in the two sheets are not in the same order of cells. e.g A2 i sheet1 may be duplicate of A325 in sheet2. I have read the instruction in this website, but I did not know wher to write the formula, should it be in a new cell, and does matter if the cells of the tw ranges are not in the same order? I mean "does the formula compare cell to cell or range to range"? Than -- wm ----------------------------------------------------------------------- wmw's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1612 View this thread: http://www.excelforum.com/showthread.php?threadid=27565 Tag: formula wording Tag: 48784
  - 2
    - Links not linking Hello I have written a fairly big spreadsheet linking through the pages with SUM, SUMIF and SUMPRODUCT formula's What I am now finding is that when I update one page it doesn't update the rest, even if I am only typing in a figure to the SUM function. I have check and the calculations function is on automatic. is there a fix or something that I could run to make sure that all the formulas are working correctly. thanks Tag: formula wording Tag: 48783
  - 3
    - Autosave Add-In Was this removed from 2003 version? I'm not referring to the autorecover for crashes. Tag: formula wording Tag: 48779
  - 4
    - H E L P with retreiving data Need A Little help figuring this on out. I need to establish a cell at the bottom of the run sheet page (example attached) or B60 that says IF the drivers name for this example is Emily THEN go to each Emily on the drivers column I4:I20 and get that total charge which is the last figure to the right T$:T20 and then add the totals for Emily and enter that total into an Emily's cell box at the bottom somewhere on the run sheet, B60 Driver column has different drivers in it of course. Copy of a run sheet example is attached. RSULLIVAN12@TAMPABAY.RR.COM Disabled American Veteran James A Haley Veterans Hospital Tampa, Florida "Remember That The Price Of Freedom Is Not Ever FREE" Tag: formula wording Tag: 48777
  - 5
    - Combo Box Dear Earl I opened the Combo Box from the Form Toolbar and I found it. Thanks lot -- chrisdtra ----------------------------------------------------------------------- chrisdtran's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1596 View this thread: http://www.excelforum.com/showthread.php?threadid=27492 Tag: formula wording Tag: 48775
  - 6
    - vlookup formula Is it possible to use a cell refence, in which the referred to cell lists the workbook and array, as the range for a lookup formula. I am attempting to use the same VLOOKUP formula to access a variety of files which are employee timesheets. I am using a CONCATENATE to build the correct file name for a given timeperiod and employee placed in CELL A1 - now I would like to insert this filename in the Range portion of the lookup file by telling the formula to look in cell A1 for the filename, but cannot seem to find a way to do this, the formula wants to find a file with the name A1. any ideas? thanks, West. -- West ------------------------------------------------------------------------ West's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16123 View this thread: http://www.excelforum.com/showthread.php?threadid=275659 Tag: formula wording Tag: 48773
  - 7
    - Changing a cells format I had some one type in some data for me and when I got it the cell box has a Little green triangle in the top left hand corner- I assume that this means it is a text format. If double click on each cell it changes the format so I can do Sum etc. But we are talking a lot of Data- Is there a way I can select the column and change the format? Or do I have to use a formula in another column? -- Let go, Elevate your life Brent Hauver www.sagehealthstore.com Tag: formula wording Tag: 48771
  - 8
    - how can I compare spread sheets? Dear All, How can I compare two data sets on two work sheets, in a way lik "compare and merge documents" function in Microsoft Word. I want to do it in a way that merge the two and get the different cell highlited without making duplication. NB: I cannot use VBA macros on my computer at work :mad: Thanx a millio -- wm ----------------------------------------------------------------------- wmw's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1612 View this thread: http://www.excelforum.com/showthread.php?threadid=27565 Tag: formula wording Tag: 48769
  - 9
    - outlook express / excel saving problem Hi When an excel file is opened as an attachment in outlook express and the changes made and saved, are the changes saved anywhere or lost when the email is closed? I have tried this and changes seem to be lost if you reopen the same xls file from an email - but does anyone know if the saved file is held in a different location anywhere? thanks MT Tag: formula wording Tag: 48767
  - 10
    - Excel 2003 doesn't save files in network disk drive WinXP Pro SP2 + Office2003 OEM All the applications open, edit and save in the netwoth HDD but Excel2003 doesn't save. It opens an existing file, we try to save it and it shows a error message related with sharing permissions. It creates a temp file but even that returns error. All other applications work perfectly. Even with a new worksheet it does the same. Does not allow to save in the network drive. The same users in other computers have no problem. It's a brand new machine, new software. Error ID 10036. Thank's -- Pedro Esteves Tag: formula wording Tag: 48765
  - 11
    - File is saved on opening Hi all, I have an Excelfile that, when I open it, immediately saves itself. have no idea why it does that and since it is a file of nearly 50 Mb, really hate to spend a lot of time to watch Excel save that 50 Mb' every time I open the file. I created the file, but after that it' been used by others. The AutoSave is not installed. This original 50Mb file contains severa macros, none of them have any AutoOpen statements, but just to be sure I copied the file and stripped it completely. I now have a file that contains no macro's and just 1 empty sheet. Th size is now 17 kb, but it still saves on opening (a lot faster than th 50 Mb :) ). I can't think of any reason why Excel would do that. An it's just those two files (the original and the copy), because when open another file, nothing happens. Has anyone a clue as to what is happening here? Is there any optio that's checked and should be unchecked? Regards, Anne -- Roadi ----------------------------------------------------------------------- Roadie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=593 View this thread: http://www.excelforum.com/showthread.php?threadid=27563 Tag: formula wording Tag: 48759
  - 12
    - Simple formula question Simple question... I have two sheets of data. I am taking (A2 * B2) * M3 (on anothe sheet) next should be (A3 * B3) * M3 but I copy and it changes M3 to M4 my issue is how do I copy this formula to other cells while keeping th M3 value from changing -- jviora ----------------------------------------------------------------------- jvioral's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1069 View this thread: http://www.excelforum.com/showthread.php?threadid=27562 Tag: formula wording Tag: 48755
  - 13
    - Duplicates We have large amounts of data we need to locate duplicates in based on a particular piece of their record. We have been utilizing a program called DigDB but it tends to be a CPU hog. Is there something in Excel natively to do the same type of thing? Dave French Tag: formula wording Tag: 48754
  - 14
    - Time conversions How do I convert an integer value into a time value in MS Excel (97)?? For example 13 becomes 00:13:00 (13 mins) or 65 becomes 01:05:00 (1hr 5mins)?? Is there a function I could use ?? Many thanks Tag: formula wording Tag: 48751
  - 15
    - Excel Time Problem I exported a file from a telephone switch reporting system as a "tab separated text" file, because when I export the data in Excel I have to deal with merged cells and other formatting problems. I have a couple of columns that have time values like 160:02:05 for logged in time, and 34:16:46 as the waiting dime? Both are time ?DURATIONS? or time in a state. I used the Format, Cell, custom and [ss] to get the duration value to seconds, and I get 123406 and 576125 respectively. I then use these numbers in a calculation typically like 1338 / (576125 - 123406) and I get 219 as the answer. The problem occurs if I do the same calculation on a calculator. The same formula 1338 / (576125 - 123406) gives 9.14 as the answer... I know that the 9.14 is in the right range for my answer. How do I get excel to give me the right number. Note: all of the other Duration values that I am using in my calculations match the calculator answer. This is the only one that does not!! ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! Free Support at http://www.ozgrid.com/forum/ ** Tag: formula wording Tag: 48749
  - 16
    - Chart setting First excuse me for my bad english :-) I realized a chart with a set of numbers on the X-axix. The problem is that the interval between each number is not constant, while the chart represents each of them at the same distance, as they were text labels. How to solve? I must use only experimental data so I cannot add not real data. It's a line chart wich represents the pH of a solution (strong acid / base titration). Thanks in advance, Andrea. Tag: formula wording Tag: 48747
  - 17
    - automatic text highlighting Hi folks, I use a spreadsheet that automatically changes the font color of the row to red if the text in a particular cell = fail. My problem is it's not working consistently (because of my editing the spreadsheet I expect) and I CANNOT find out how it's done. There's no macro and no hidden cells that I can find that perform this text coloring task. Has anyone an ideas of how it's been done? Thanks Glenn Tag: formula wording Tag: 48742
  - 18
    - How do I set the default zoom to 90% ? (i.e. not 100%!) ms Excel 2002 /Windows 2000 Pro Hi How do I set the default zoom to 90% rather than 100%? I have a high resolution monitor, and have set the MS Windows 2000 text size to large. But in excel it is slightly too large and I keep needing to zoom out... Or is there a setting to change the screen DPI or something...?! Any suggestions? Ship Shiperton Henethe Tag: formula wording Tag: 48741
  - 19
    - Show the max value of a column according to a given date and show its definition Given: For Sheet1: A1: 11/2/04 (This is the current date) A4: Project Code A5: Dent A6: Stain B4: 11/3/04 B5: 10 B6: 5 C4: 11/4/04 C5: 12 C6: 20 Question: How can I have the maximum number value of the current dat displayed in A1? Desired Solution: A15: (this cell will display the max value of the column given by th current date.) B15: (this cell will display the Reason Code of the max value of th current date) Logic: If the date in A1 is changed, the value of A15 and B15 will b changed as well regarding to the current date in A -- Shadow_Otix ----------------------------------------------------------------------- Shadow_Otixz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1597 View this thread: http://www.excelforum.com/showthread.php?threadid=27555 Tag: formula wording Tag: 48740
  - 20
    - Protect a worksheet in Excel2000 When I use the protect function in Excel XP, it provides a lot o options to choose. E.G. I can choose to enable an user to format row after the sheet's protected., i.e. hide/unhide. Can I do something similar in Excel 2000? :eek -- Jason ----------------------------------------------------------------------- Jasons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1610 View this thread: http://www.excelforum.com/showthread.php?threadid=27554 Tag: formula wording Tag: 48735
  - 21
    - Drag Formula cell to decrement the cells I have a 20 different values starting from A1 till T1 I need to do automatically (by dragging a formula cell) that U1=T1 V1=S1, W1=R1 ........... AN=A1 (mirror of A1 till T1) Can someon -- Asher Zu ----------------------------------------------------------------------- Asher Zur's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1610 View this thread: http://www.excelforum.com/showthread.php?threadid=27554 Tag: formula wording Tag: 48734
  - 22
    - looking for solution I tried to figure out how to customize column B and column C of this formula to return custom messages if each column returns a false entry. {=INDEX(S1!$D$2:$D$7932,MATCH(1,((S1!$A$2:$A$7932=$B14)*(S1!$B$2:$B$7932=$C14)*(S1!$C$2:$C$7932=$E14)),0))} Im still a beginner and I unsure as to what function to use. Any help would be appreciated. Rusty Tag: formula wording Tag: 48729
  - 23
    - summing values in certain months I have used the count number of dates appears in certain months: =sum((month(a2:a11)=b2)*(year(a2:a11)=c2)*1) quite successfuly. Now I need to add the values in another column fo that month. So in other words, search column a2 to a11 with the dat specified and if there is a value in column d then add all the value together and give me a total money received for that month. Thi should be easy, but I seem to be stuck, I have problems with arrays i that this workbook is shared and will only let me edit arrays if unshare the workbook. i would appreciate any help anyone can give me. thanks agai -- GORDO ----------------------------------------------------------------------- GORDON's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=616 View this thread: http://www.excelforum.com/showthread.php?threadid=27552 Tag: formula wording Tag: 48725
  - 24
    - Password How do I crack the password on an excel file. I recieve a file each month and would like to maniapulate it but it asks for a password -- must be in the file somewhere -- can anyone help ?? Thanks SLD ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: formula wording Tag: 48722
  - 25
    - Formulas sometimes will not work in a Column or cell? I am perplexed a bit with an annoying problem that is user error I am sure: Most of the time, I can go to a cell and type in =F8+G8 and I get wonderful number that comes out. But other times the output will be "=F8+G8" and the whole column is that way? I think that this is because the column is text format.. so I select the column and format for Numeric- but nothing happens I still get "=F8+G8"- What can I do to format that column so I can do some formulas? Thanks brent Tag: formula wording Tag: 48715
- Next
  - 1
    - Quick key for Paste special Anyone know the Quick Key for Paste Special? Thanks brent Tag: formula wording Tag: 48714
  - 2
    - line width How do I set the line width (thickness) for a vertical or horizontal line? Tag: formula wording Tag: 48713
  - 3
    - Quick key for Paste Special Tag: formula wording Tag: 48712
  - 4
    - Inventory control problem I'm a first timer using xls for inventory control but ran into problem. I have 2 columns Pulled and Returns. When you first inpu numbers in it calculates the Inventory on Hand correctly. The proble is that the inputs are done daily and when delete the old numbers i the 2 columns and input the new ones...it disregards the previous day numbers. Is there a formula or function that I can use that would giv me a running total on those two columns. Any suggestions would b greatly apprec. Thanks......Bunj -- Bunj ----------------------------------------------------------------------- Bunji's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1610 View this thread: http://www.excelforum.com/showthread.php?threadid=27549 Tag: formula wording Tag: 48711
  - 5
    - Macro to delete an entire row with cells missing a specific chartacter Dave, That got the job done, but I need something that is less intensive fo the less proficeint ppl at the office, that's why I am trying to buld macro. Thanks for your help :cool: Dave Peterson Wrote: > If I were doing it manually, I'd apply data|filter|autofilter to tha > range. > > Then filter on that column using custom. > Show the cells you want to delete > (Does not contain maybe very useful!) > > Select those visible cells (avoiding the header) > rightclick|delete > > > > asf wrote: > > > > Hey Harald, > > > > This is the script I am using to remove "IS" > > > > Sub Findanddelete_IS() > > Dim rng As Range > > Dim what As String > > what = "IS" > > Do > > Set rng = ActiveSheet.UsedRange.Find(what) > > If rng Is Nothing Then > > Exit Do > > Else > > Rows(rng.Row).Delete > > End If > > Loop > > End Sub > > > > So...my programming experience is a tiny bit limited, not sure ho > to > > delete anything missing the IS as opposed to containing the IS. I > > understand in theory but my knowledge of syntax is the limiter. > > > > Harald Staff Wrote: > > > Hi Asf > > > > > > This is far more useful if you figure it out yourself, sinc > you're > > > pretty > > > close. How do you remove rows if there IS an @ in B column ? (Pos > code > > > or > > > method if you're stuck) > > > > > > HTH. Best wishes Harald > > > > > > "asf" <asf.1f7sq0@excelforum-nospam.com> skrev i melding > > > news:asf.1f7sq0@excelforum-nospam.com... > > > > > > > > Hi all, this forum is a lifesaver. > > > > > > > > Quick question, I know how to remove a row if there is > specific > > > > occurrence but how do I do the opposite, remove a row withou > the > > > > specific occurrance? > > > > > > > > For example I have an email list with Col. A = Name, Col. B > email. > > > I > > > > need to remove all the rows with emails in col. B without th > "@" > > > > symbol (basically get rid of invalid email entries). > > > > > > > > Thanks!! > > > > > > > > > > > > -- > > > > asf > > > > > > > ------------------------------------------------------------------------ > > > > asf's Profile: > > > http://www.excelforum.com/member.php?action=getinfo&userid=14933 > > > > View this thread: > > > http://www.excelforum.com/showthread.php?threadid=275429 > > > > > > > > -- > > asf > > ------------------------------------------------------------------------ > > asf's Profile > http://www.excelforum.com/member.php?action=getinfo&userid=14933 > > View this thread > http://www.excelforum.com/showthread.php?threadid=275429 > > -- > > Dave Peterson > ec35720@netscape.co -- as ----------------------------------------------------------------------- asf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493 View this thread: http://www.excelforum.com/showthread.php?threadid=27542 Tag: formula wording Tag: 48707
  - 6
    - remove name from comment form my computer user name appears automatically in every comment form (right click on cell>insert comment). i have tried deleting computer registration, but it hasn't changed. i don't want to see my name in every comment . it's pointless. where in the registry (or elsewhere) can i go to delete it? so that i can start with a blank comment. tia jeffrey Tag: formula wording Tag: 48700
  - 7
    - Macro to delete an entire row with cells missing a specific chartacter Hey Harald, This is the script I am using to remove "IS" Sub Findanddelete_IS() Dim rng As Range Dim what As String what = "IS" Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop End Sub So...my programming experience is a tiny bit limited, not sure how t delete anything missing the IS as opposed to containing the IS. understand in theory but my knowledge of syntax is the limiter. Harald Staff Wrote: > Hi Asf > > This is far more useful if you figure it out yourself, since you'r > pretty > close. How do you remove rows if there IS an @ in B column ? (Post cod > or > method if you're stuck) > > HTH. Best wishes Harald > > "asf" <asf.1f7sq0@excelforum-nospam.com> skrev i melding > news:asf.1f7sq0@excelforum-nospam.com... > > > > Hi all, this forum is a lifesaver. > > > > Quick question, I know how to remove a row if there is a specific > > occurrence but how do I do the opposite, remove a row without the > > specific occurrance? > > > > For example I have an email list with Col. A = Name, Col. B = email > I > > need to remove all the rows with emails in col. B without the "@" > > symbol (basically get rid of invalid email entries). > > > > Thanks!! > > > > > > -- > > asf > > ------------------------------------------------------------------------ > > asf's Profile: > http://www.excelforum.com/member.php?action=getinfo&userid=14933 > > View this thread > http://www.excelforum.com/showthread.php?threadid=275429 > -- as ----------------------------------------------------------------------- asf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493 View this thread: http://www.excelforum.com/showthread.php?threadid=27542 Tag: formula wording Tag: 48699
  - 8
    - Macro to delete an entire row with cells missing a specific chartacter Hi all, this forum is a lifesaver. Quick question, I know how to remove a row if there is a specifi occurrence but how do I do the opposite, remove a row without th specific occurrance? For example I have an email list with Col. A = Name, Col. B = email. need to remove all the rows with emails in col. B without the "@ symbol (basically get rid of invalid email entries). Thanks! -- as ----------------------------------------------------------------------- asf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493 View this thread: http://www.excelforum.com/showthread.php?threadid=27542 Tag: formula wording Tag: 48697
  - 9
    - Macro to put data in a new column following specific characters I need to create a macro that goes through a single column, and ever time a specific character set such as 3 periods "..." occurs anythin after the "..." is put into a new column. So say I have all of the following in column A: I go...to the...store I need it to turn into: Column A: I go Column B: to the Column C: store Thanks in advance, any help is GREATLY appreciated!! : -- as ----------------------------------------------------------------------- asf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493 View this thread: http://www.excelforum.com/showthread.php?threadid=27542 Tag: formula wording Tag: 48696
  - 10
    - Exporting to notepad Is there an easy way to expor the data inside of Excel into notepad? Thanks. Aaron Tag: formula wording Tag: 48690
  - 11
    - An instant sorting problem Dear all, I have a list of data in 2 columns: Column A stores 1000 names of students and Column B stores the scores of the corresponding students. If I want to make a sorted list of data in Columns C and D with descending scores, what formulas should I use in columns C and D? It should be noted that some students may get the same score. The order of these students in the sorted list is not important as long as they are in adjacent rows. Best Regards, Chris Tag: formula wording Tag: 48687
  - 12
    - Save Entire Workbook as Values Hi - I've a spreadsheet with lots of formulas which pull in data by dat - therefore the data changes everyday... Just wondering if anyone knows a way I can save the entire workbook a values in order to maintain a record of all the data...? Many Thanks -- ddmmyyy ----------------------------------------------------------------------- ddmmyyyy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1608 View this thread: http://www.excelforum.com/showthread.php?threadid=27534 Tag: formula wording Tag: 48686
  - 13
    - Best Hardware If you were to design a machine from scratch and the primary goal was that Excel could fly, what would the machine's specs be? Multi-vs-single processor? Gigabytes of RAM? Faster spinning HD's? What do you think? Tag: formula wording Tag: 48680
  - 14
    - Font in Combo Box I have a form that someone created that has several combo boxes that were created with the Control Toolbar. When the information displays from a selection in the Combo Box the font is rather small and I have been trying to find where I can enlarge the font from the selection within the combo box. Can someone help? Thank you in advance. Ray Tag: formula wording Tag: 48677
  - 15
    - Editing of comments - Excel will not allow. But thankyou very much -- Jacqu ----------------------------------------------------------------------- Jacqui's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1606 View this thread: http://www.excelforum.com/showthread.php?threadid=27523 Tag: formula wording Tag: 48676
  - 16
    - GradeBook Spanks. That worked for the numbers. Now my problem is the Final Grade Average. It's counting the empt cells as 0 and putting it into the average. Here is my formula for that: =AVERAGE(C5+D5+H5,K5+L5+P5,S5+T5+X5,AA5+AB5+AF5,AI5+AJ5+AN5,AQ5+AR5+AV5,AY5+AZ5+BD5,BG5+BH5+BL5,BO5+BP5+BT5) So say I only have data inputted for C5, D5, and H5, but the rest ar blank, then the above formula computes the empty cells as zero. Do I try that ISNUMBER there somehow or is there another way -- WannaKook ----------------------------------------------------------------------- WannaKooky's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1593 View this thread: http://www.excelforum.com/showthread.php?threadid=27524 Tag: formula wording Tag: 48675
  - 17
    - Prompt by macro Hi I am building a macro which involves opening a file and saving the file with a different name after performing certain actions. Is it possible macro prompts to enter the file name as to which file to open and prompt again as to what name file should be saved. thanks in advance Nadeem Tag: formula wording Tag: 48669
  - 18
    - Delete does NOT delete Excel 97, SR2 Using large spreadsheets. Doing lots of cut & paste and deletes Finished spreadsheet gets exported/merged with our main operation data-base ( not d-base or anything like that ) Have found that a delete ( and cut & paste?) actually leaves everything in the file (althought hidden to the eye). Afer some manipulation of the file, the file becomes hugh! This messes up our export/merge, big time. Our internal "fix" has been to convert to CSV (comma seperated values), and reformat to get the required appearance back. 1: Is there a way to properly clean up the file so that what is on the screen, etc., is actually what is in the file? 2: Do the newer versions of Excel ( 2003? ) have a built in fix? (for this specific problem? (As we see it)) -- John F. Scholten Tag: formula wording Tag: 48668
  - 19
    - GradeBook I've developed an amateur's gradebook. I'm not very advanced in Exce and its formulas. Here is my format and the formulas I have used and m questions: I give 2 grades a week which I average all out at the end of a schoo quarter (9 weeks). Each week is divided into grade factors: 1 Column for Lesson (Points given based on 0-4 scale) 1 Column for Test (Points given based on 0-4 scale) 1 Column for Effort (Points given based on 0-4 scale) 1 Column for Conduct (Points given based on 0-4 scale) 1 Column for Days Missed in the Week 1 Column for Points Given Based on Missed Days (Points given based o 0-4 scale) 1 Column for Letter Grade based on addition of Lesson, Test, and Day Missed Pts 1 Column for Letter Grade based on addition of Effort, Conduct, an Days Missed Pts LAST 2 COLUMNS BASED ON THIS FORMULA =IF(C4+D4+H4>=11,"A",IF(C4+D4+H4>=9,"B",IF(C4+D4+H4>=7,"C",IF(C4+D4+H4>=5,"D",IF(C4+D4+H4<=4.99,"F"))))) This is repeated for every week (9 weeks). At the end I have columns: 1 Column for Average of Lesson, Test, Days Missed FORMULA =AVERAGE(C4+D4+H4,K4+L4+P4,S4+T4+X4,AA4+AB4+AF4,AI4+AJ4+AN4,AQ4+AR4+AV4,AY4+AZ4+BD4,BG4+BH4+BL4,BO4+BP4+BT4) 1 Column for Letter Grade Based on Average FORMULA =IF(BW4>=11,"A",IF(BW4>=9,"B",IF(BW4>=7,"C",IF(BW4>=5,"D",IF(BW4<=4.99,"F"))))) 1 Column for Average of Effort, Conduct, Days Missed 1 Column for Letter Grade Based on Average Here is what I need: Each Week comes out with F because of no points. I'd like to know how could avoid having the F there without inputting data. I don't want t demoralize the kids. Also, I'd like the Final Grade to compute the current average and no average out everything because it's giving the Final Grade as F base on what I have now. Any help would be greatly appreciated. Thanks -- WannaKook ----------------------------------------------------------------------- WannaKooky's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1593 View this thread: http://www.excelforum.com/showthread.php?threadid=27524 Tag: formula wording Tag: 48667
  - 20
    - Editing of comments - Excel will not allow. I have a spreadsheet which does not allow me to edit comments created b other users, by right clicking on the cell. Other users can only edi their own comments. There is no protection on the worksheet o workbook. The only way edit will be allowed, is to Show the comment, then it ca be edited. Any help would be appreciated - thankyou. Version is Excel 97 OS is WINNT Compaq PC no protection on cell, or worksheet Comments are set to display indicator only There are no formulae in the cells There is no conditional formatting in the cells -- Jacqu ----------------------------------------------------------------------- Jacqui's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1606 View this thread: http://www.excelforum.com/showthread.php?threadid=27523 Tag: formula wording Tag: 48665
  - 21
    - Merging data from two worksheets? Thanks for your help. I'll take a look. : -- legal_eagl ----------------------------------------------------------------------- legal_eagle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1603 View this thread: http://www.excelforum.com/showthread.php?threadid=27498 Tag: formula wording Tag: 48664
  - 22
    - Function to find largest number from a series of numbers? Is there a function to go across several columns of numbers and pick out the largest one? If not, how would I write that function? thanks to all Rick Tag: formula wording Tag: 48660
  - 23
    - Online activity tracker Hi My company wants me develop a tool (an online activity tracker) which can be deployed over LAN and helps a project manager keep track of the activities of the team members.The tool should notify the Project Manager whenever a team member finishes a task and updates his/her assignment.Such tools are available in the market but are very expensive.Can such a tool be developed in excel and deployed over LAN ? Vivek -- Vivekexcel ------------------------------------------------------------------------ Vivekexcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16058 View this thread: http://www.excelforum.com/showthread.php?threadid=275175 Tag: formula wording Tag: 48659
  - 24
    - Automating Hi, I have 8 Excel Spreadsheets that gather data from an External Data Source. I'd like to somehow schedule these files to open, refresh the data, and then close some stage at night so the data is fresh for when the user gets in. (it takes about 5 minutes to update each workbook). Does anyone have any ideas? Thanks Marek Tag: formula wording Tag: 48658
  - 25
    - Help with easy LOOKUP formula please Could someone please tell me how to lookup a date in one row that matches a minimum number in another row? Specifically - Row 1 contains dates. Row 2 contains the DOW averages for those dates. At the end of Row 2 (say column Z) my formula finds the smallest (MIN) number in the row. In Row 1, Column Z, I would like to put the LOOKUP function that finds the corresponding date of the value found in Row 2, Column Z. In other words, I need to lookup the date in Row 1 that corresponds to the lowest DOW average found in Row 2. I'm sure this is a piece of cake for those in the know, but I sure can't figure it out. Any help would be hugely appreciated. -- Thanks. - Butch, Pennsylvania Tag: formula wording Tag: 48654

i dont know if you can do this.....
if(c5=10, take the cell 5 right 3 down to it, 0)
if you can, i dont know how to write it in excel language
thanks if anyone can hel

--
cutsygur
-----------------------------------------------------------------------
cutsygurl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1504
View this thread: http://www.excelforum.com/showthread.php?threadid=27569

Top

Re: formula wording by BenjieLop

BenjieLop
Fri Nov 05 13:16:15 CST 2004

cutsygurl Wrote:
> i dont know if you can do this.....
> if(c5=10, take the cell 5 right 3 down to it, 0)
> if you can, i dont know how to write it in excel language
> thanks if anyone can help

Try this ...

=if(C5=10,offset(C5,3,5),0

--
BenjieLo

-----------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1101
View this thread: http://www.excelforum.com/showthread.php?threadid=27569

Top