Question about Microsoft Office Standard for PC

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

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

It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Jul 20, 2009 | IBM ThinkPad T42 Notebook

use if statement

=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)

where A1=T2 and B1=U2

=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)

where A1=T2 and B1=U2

Jul 16, 2009 | Microsoft Office Excel 2007

You need to change the =IF(AND to =IF(OR

Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

Apr 16, 2009 | Oracle Database Enterprise Named User Plus

Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.

Mar 06, 2009 | Microsoft Office Excel 2003 for PC

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

Suppose the value for $ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

Nov 15, 2007 | Computers & Internet

Aug 20, 2013 | Microsoft Office Standard for PC

34 people viewed this question

Usually answered in minutes!

×