#### Simple Formula for simple person. :)

```Hi,

I'm typing up a basketball boxscore template and need the formula to work
out shots made over shot attempts. I know this is a simple percentage but
I'm not sure what form this would take in the function window.
Any help would be appreciated. Thanks

The Excel Noob.

```
 0
John4907 (2)
5/5/2004 3:15:25 AM
excel 39879 articles. 2 followers.

1 Replies
680 Views

Similar Articles

[PageSpeed] 59

```Okay, I learnt to read.  *blush*

```
 0
John4907 (2)
5/5/2004 3:55:16 AM

Similar Artilces:

Simple graph
I have a chart with zip codes and a population rate. ZIP RATE 80001 2.34 80002 1.23 80003 1.23 I want to make a chart that has the rate on the x axis and the number of times that rate occurs on the y axis. | | | * | | * |_________________________________ | | 1.23 2.34 Thank you. I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1) Label in G1 to read RATE (but leave it empty for now), label in H2 to read COUNT Make a list of rates in G2:G20 (say) In H2 =COUNTIF(\$B\$2:\$B\$200,G2) Copy down the row Select H1:G20 and make a...

Excel formulas #21
I am creating a spreadsheet that tracks our current staff across the country. Is there a way to create a formula that counts from two different fields. For example I want the total number of people if Column B reads "ATLANTA" and column F reads "ACTIVE" I was thinking I could use COUNTIF somehow....but can't quite figure it out One way =SUMPRODUCT(--(B2:B100="ATLANTA"),--(F2:F100="ACTIVE")) you could replace the criteria with cell references so it be easier to change criteria, also note that unlike countif you can't use the whole column...

formula #48
=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("DIVS",A4)),ISERROR(SEARCH("FUND",A4))),"", IF(LEN(A4)>3,1,"")) i have this formula which should return a value of 1 if A5 contains more than 3 letters except if A5 contains CMT, DIVS or FUND what am i missing? many thanks Well, I'm assuming you mean "A4", not "A5", in your statement. If A4 is the target cell, try: =IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*","*fund*"}))>0),"",1) HTH Jason Atlanta, GA "Micay...

Req: Formula Array.....
Hi all, Have an XLS and trying to generate stats from it. On one Worksheet I would like to break up stats in the following manne (for example).. Code ------------------- Ongoing Closed July Client Praises ?? ?? Complaints ?? ?? Vendor Praises ?? ?? Complaints ?? ?? Partner Praises ?? ?? Complaints ?? ?? The data contained on another Worksheet is in the following format: Col#01 - Date (Format: `dd - mmm - yy`) Col#02 - T...

Simple help with implementing Outlook-like GUI
Hi All. I am an experienced unix programmer who sometimes has to do something in the windows world, and always has newbie-questions. Basically I want to write an application program that looks like outlook in that it has nice icons down the left hand side that choose the content of the main area in the right hand side. So I started the MFC App wizard, and got me a SDI program with a CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd). Then I prepared the following snippet of code to draw the buttons: // Create a pushbutton CBitmapButton* pmyButton; pmyButton = new CB...

Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo calculating square inches. Column A: Height Column B: Legnth Column C: Total Tags per 16 x 24 Column D: Cost per tag Figures I know: each sheet cost me \$9.98. each sheet is 16 x 24 inches What I want to do is enter the Height, enter the Length and have th total (sum) be entered into columns C and D. I can't believe I forgot how to enter formulas. Any help will b appreciated. Thank you, Crai -- Message posted from http://www.ExcelForum.com Hi Craig, One Way, might be better ways but this'll work: List the colou...

drag and drop from Inbox to personal folder
MS Outlook freezes up when trying to drag and drop mail from Ibox to a personal folder? ...

vlookup formula #4
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C8FEBA.BDA26D90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: base64 SSBoYXZlIHNvbWUgcGFydCBudW1iZXJzIHRoYXQgSSBhbSBzZWFyY2hpbmcgZm9yIGV4dGVybmFs bHkgdXNpbmcgdGhlICJGYWxzZSIgcXVhbGlmaWVyLiAgU29tZSBmaWVsZHMgcmV0dXJuIGEgdmFs dWUgb2YgIiNOL0EiICBhcyB0aGVyZSBpcyBubyB2YWx1ZS4gIENhbiBhbnlvbmUgaGVscCBtZSB3 aXRoIGEgZm9ybXVsYSB0byByZXR1cm4gYSBmaXhlZCB2YWx1ZSAoaS5lLiAxLjApIGlmIHRoZSBm b3JtdWxhIHJldHVybnMgIiNOL0EiIGFzIGEgdmFsdWU/DQoNCg0KVEhhbmtzDQoNClBhdWw= ------=_NextPart_000_0008_01C8FEBA....

Simple hack to get \$500 to your home. 06-05-10
Simple hack to get \$500 to your home at http://uknews.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...

Simple Query Wizard hangs
I am using Access 2003 When I initiate the "Simple Query Wizard", I am presented with the first screen - "What fields do you want in your query" When I click on the pulldown list to select a table, I get the following message: "The expression On Get Focus you entered as the event property setting produced the following error: the text you entered isn't an item in the list * the expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the function, event, or macro&q...

Combining Text with Formula
Is is possible to have a cell contain text information and then a lookup to another cell. For instance: "The age of this person is " plus the result of another cell that calculates his age so that cell would read: "The age of this person is 72." Thanks for any help you can give me. DebraAnn DebraAnn, yes. =The age of this person is "&B1&"." where B1 holds the calculation. -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "DebraAnn" <anonymous@discussions.microsoft.com> wrote in...

I Need a Simple Sales Software
Hello, I am looking for software to keep track of my prospects, customers, and the notes of the sales process. I spend about one hour a day on sales and marketing, so I prefer a simple and inexpensive software. Maximizer, Outlook, Act, and Goldmine seem made for the full-time professional salesperson. Please let me know if what I am looking for exists. Best Regards, T.I. ...

Formula #21
I am making a worksheet in excel and I have a YES NO cells. I would like to be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use a "if" formula? -- ml format>conditional formatting>cell is equal to yes>format as desired -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "cybersox" <cybersox@discussions.microsoft.com> wrote in message news:009549FA-3704-4A4F-8492-DCB9ECAF2B65...

Make it more simple or intuitive to do simple things
I appreciate the fact that applications are becoming more versatile and able to do things that we hardly thought possible in the past but I feel that in this added complexity you are losing sight of the need to do simple things easily without resorting to trial and error or consulting "help" which often anyhow doesn't lead one straight to the solution! An example is how to produce a chart with a series of months i.e Jan Feb Mar etc appearing on the X axis. This is no doubt something that resulted naturally in the first versions of Excel charts or in a competitor's ea...

Simple public folder permission problem
I have a public task list folder. However even though I have given everyone "Author" priviledges and full control of the directory, users cannot update the tasks (although they can create new ones). The changes to tasks get reset to their original values. Where should I look to fix this problem? Brian How did you grant Author Access, via Outlook or ESM? What do you meanyou gave them full control of the directory? "Brian Taylor" <taylorb@newsgroups.nospam> wrote in message news:e2hwumGrEHA.1160@tk2msftngp13.phx.gbl... > I have a public task list folder. Ho...

Can multiple criteria be used for IF formulas?
I am using the below formula to calculate percent of change from one year to another year. =IF(F3=0,1,U3/F3-1) F3 being the amount spent in previous year U3 being amount spent in current year The question I want my formula to answer is: If F3 and U3 have a quotient greater than zero, then calculate. However, I also want it to yield a 100 answer if the F3 is zero AND I also want it to yield 0 if both F3 and U3 are zero. -- Thanks, Christine Please see responses to your later reposting. ----- original message ----- "CHaney" wrote: > I am using the b...

What is simple text?
When creating a custom list that includes a column of accounting formated data, I get an error message that 'fields without simple text will be ignored'. The result is all other data except the accounting formatted data. Help!!!! I suppose it means without the currency symbol and thousands delimiters. On Fri, 8 Apr 2005 11:01:04 -0700, TexMas <TexMas@discussions.microsoft.com> wrote: >When creating a custom list that includes a column of accounting formated >data, I get an error message that 'fields without simple text will be >ignored'. The result is ...

Transpose formula
i have a data entry sheet which reads: A B C D E etc Week 1 Week 2 etc Actual Target Actual Target etc Pre-starts 5 5 2 4 Startups 10 6 12 15 Established 15 7 15 20 I need a summary sheet which transposes these figures to the following A B C D ...

If formula for date range
I am trying to set up a formula to check milestones which fall between 15 days + or - of todays date using IF. If the result matches I want the true value to be text in another cell. I've come up with the formula to check if it matches today (see below) but am having problems when trying to add in the +/- 15 days. =IF(C17=B26,B17,0) C17 is milestone date B26 is todays date B17 is milestone description I also want to extend this to multiple cells. Any help would be appreciated. -- rediproof ------------------------------------------------------------------------ rediproof's ...

Update to formula
Is it possible for a formula to look in cell and check if it contains specific text? I was provided the following formula, below, but it only checks to see if cell value contains only those values but not if it includes it. For example: cell value - Test0408AU ="Exist" =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408SL","0408","0109","0209","0309","0409"},A1)),"Exist","Cannot find") Search accepts wildcards, so if you want to search for cont...

Named Formula Problem
I like to put calculations that are used in more than 1 place in a Name so that if I need to change them I can just change them in one place. However there is one calculation that will not work when it is referred to by name, always returning the #VALUE error. Exactly the same calculation in a cell works perfectly. The calculation is : -SUMIF(INDIRECT(ADDRESS(RowFirstData,COLUMN()+1)&":"&ADDRESS(ROW()-1,COLUMN( )+1)),INDIRECT(ADDRESS(ROW(),COLUMN()+1)),INDIRECT(ADDRESS(RowFirstData,COLU MN())&":"&ADDRESS(ROW()-1,COLUMN()))) RowFirstData is a name contai...

Invalid and duplicate personal folders in Outlook 2003
I have duplicate personal folders that cannot be deleted and appear to be corrupted. I copied an Outlook 2002 .pst file to my new Outlook 2003 and all was fine, but I could not set reminders due to an error. I followed the advice of a knowledgebase article, but then got the duplicate Personal folder that was identical and could not be deleted. After that I tried more things, but I cannot delete these duplicate folders. There seems to be no command, and closing the folder returns an error. HELP!!! Never overwrite a PST file. You have a corrupted profile. Do you still have your ori...

Increment Formula
I use the following formula to pull values from an external spreadsheet. If I use the Auto-fill option to populate cells in the destination file it copies the formula exactly. How can I get it to increment the last digit when copying down a column ='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044 Piping Line List Rev 0.xls]LINE LIST'!\$AJ\$7 -- Posted via a free Usenet account from http://www.teranews.com Remove the last \$ ='Q:\COP\06-243 FCC Energy Recovery Detailed\ENGINEER\Lists\[PN 2005044 Piping Line List Rev 0.xls]LINE LIST'!\$AJ7 The 7 wi...

Referencing a macro in an Excel formula
Is it possible to reference a macro in an Excel formula. I want to create a formula that if a condition does not exist in a cell on that line, then delete the entire line. Is a macro the way to go or is there some other way? ...

simple question
Okay, I have a very simple question. Where do the old posts go after they run off the last page of this newsgroup? Sometimes I would like to refer to a post that I remember seeing in October, but is no longer on the current section. The search function seems to only search current posts as well. If anyone has some input please email me at joep@siboneylg.com Thanks kindly. have you tried google groups, they keep archived old posts: http://groups.google.co.uk/groups?q=microsoft.public.greatplains&hl=en "Joe Proehl" <joep@siboneylg.com> wrote in message news:099701c5...