Question about Microsoft Excel for PC

1 Answer

Thank you! For some reason I was using a colon instead of the operand between the numbers. Thanks again.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 56 Answers

Hello,

You can use a colon to find a function over a group of cells. For example "=AVERAGE(D1:D10)" would find the average of the values within cells D1 through D10.

Hope that Helps

Posted on Jun 11, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

The outreach program for the holiday season How to write a good letter on why you and your family should be eligible for the program


Start with a list of reasons. Now put your reasons with sentences that best describe your reasons and or situation in complete sentences. Maybe catagorize in the paragraphs most important things first. Remember to use spell check. Your closing should be something like, Thanks For Your Consideration or even just Thank You. Make sure all points are clear and make sense. Good luck!

Sep 24, 2014 | Microsoft Word Business & Productivity...

2 Answers

Word says it can't open


I assume it was working earlier? If so, there could be several reasons - first try loading from the "start/programs" menu instead of a desktop icon - the latter may be corrupted
Before doing more BACK UP YOUR WORD FILES to a USB (or whatever) drive
Next go to to control panel, select Programs and features" find the MS Office line and select "repair" Be careful not to uninstall.
If all that fails, do you have the original disks? If so reinstall using the OEM disk
If still no good call Microsoft -they can be very helpful. If you have the user name and licence number they can issue a new licence key

If all else fails, download Open Office (free) and use that instead of MS Word. It will read and write to all the MS files

Jul 20, 2014 | Microsoft Word Business & Productivity...

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: ...


Let say you have table like this
' A ' B
---'--------------'-----------
1 ' First ' 2
2 ' Second ' 1
3 ' Third ' 3
On Cell C1 or other cell you like, try to type this formula
=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))



That's all, just IF and math operand

11_16_2012_10_24_08_am.png

Apr 05, 2011 | Microsoft Excel for PC

2 Answers

My pc is operate slowly @automaticaly refresh again again some softwere showing runtime error


if you change the scaning format to manual scan instead of using auto scan you wont be scaning your computer every time you reset it

Feb 19, 2011 | Symantec Norton 360 Full Version for PC...

1 Answer

Hi, I have restaurant pro express v 12.0. Is


You could program a key at bottom with the ON SCREEN KEYBOARD function using the TOUCH SCREEN SETUP. This will let you manually type in the item number or bar code number. One thing to note, if you do not use bar code numbers as your item numbers, you can still make this work. On your inventory screen, click on the green check box beside ALTERNATE SKU. Then type or scan the bar code and ENTER and SAVE. You now have both an item # and bar code # that will reference your items.

Nov 07, 2010 | Pc America Restaurant Pro Express

2 Answers

HOW TO STRIP DELIMITED CHARACTERS FROM SPREADSHEET


The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.

The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.

For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.

The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.

The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).

How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.

Please ask any questions.

Dec 18, 2007 | Microsoft EXCEL 2004 for Mac

1 Answer

Not equal to


using MS EXCEL: start the operand with the following: IF _<>_value is true, value is false example: Not equal to A1<>B1, IF A1 not equal to B1

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

62 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...