Question about Microsoft Excel for PC

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

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

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 Computers & Internet

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

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 Computers & Internet

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.

- All formulas begin with an equals sign
**(=)**. - 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. - 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. - 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. - 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

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

' 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

Apr 05, 2011 | Microsoft Excel for PC

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...

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

format and re-install WinXP

Feb 26, 2010 | Microsoft Windows XP Professional SP3 Full...

The only thing I see wrong in your formula is a missing colon.

COUNTIF($C$2:$C$999,C2)=1

COUNTIF($C$2:$C$999,C2)=1

Mar 03, 2009 | Microsoft Excel for PC

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.

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

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

Jan 28, 2016 | Microsoft Excel for PC

62 people viewed this question

Usually answered in minutes!

×