Question about Computers & Internet

Hi,

Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link

http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Posted on Feb 06, 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

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

most of the times computer viruses can cause such problems, try scanning you pc for viruses. if you store you files in bad external memory like,flash drives etc these can also be the problem.

some times these viruses corrupt the programs so if try uninstalling and re installing the programs NB your files saved on your system will not be lost

some times these viruses corrupt the programs so if try uninstalling and re installing the programs NB your files saved on your system will not be lost

Apr 27, 2010 | Microsoft Office Professional 2007 Full...

{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

insert a row above row 1 and use data>filter>autofilter

view your database however you like

view your database however you like

Nov 18, 2008 | Microsoft Excel for PC

It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

1. Open up both workbooks.

2. Copy one worksheet from one workbook to another using.

Right click on the tab of one book and Select "Move or Copy"

3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.

4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.

5. Sort each worksheet by students name. Data..Sort.

6. Copy the scores from one sheet to another.

7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

2. Copy one worksheet from one workbook to another using.

Right click on the tab of one book and Select "Move or Copy"

3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.

4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.

5. Sort each worksheet by students name. Data..Sort.

6. Copy the scores from one sheet to another.

7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

That depends on which version of Excel you are using.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.

Sep 17, 2007 | Microsoft Office Standard for PC

135 people viewed this question

Usually answered in minutes!

R67YJU

×