Question about Apple MacBook Air

Ad

Shift + 8

Posted on Mar 13, 2011

Ad

I Believe you are looking for the " * " which would be- ( shift +8 )

The mathematical operators used in Excel formulas are similar to the ones used in math class.

- Subtraction - minus sign (
**-**) - Addition - plus sign (
**+**) - Division - forward slash (
**/**) - Multiplication - asterisk (
*****) - Exponentiation - caret (
**^**)

Posted on Mar 13, 2011

Ad

it is all in the formula that you put in the function bar

go google and down load a pdf version of excel to see what the formula is

go google and down load a pdf version of excel to see what the formula is

Nov 11, 2016 | Computers & Internet

Here is an example:-

We have to calculate result on the basis of marks.

1. Select answer range and click in formula bar

2. Type following formula

=if(d5:D9>=40,"Passed","Failed")

3. Now Press CTRL+SHIFT+Enter key

4. Observe the result in answer range and formula in formula bar, notice { } braces come automatically when we press CTRL+SHIFT+Enter key for an array.

For more clarification please mail on [email protected] with screenshots.

We have to calculate result on the basis of marks.

1. Select answer range and click in formula bar

2. Type following formula

=if(d5:D9>=40,"Passed","Failed")

3. Now Press CTRL+SHIFT+Enter key

4. Observe the result in answer range and formula in formula bar, notice { } braces come automatically when we press CTRL+SHIFT+Enter key for an array.

For more clarification please mail on [email protected] with screenshots.

Apr 13, 2014 | Microsoft Excel for PC

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

Hello this is Baris,

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | 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

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

the formulae for the surface area of round disc is

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

Feb 27, 2008 | Computers & Internet

sorry, I need a bit more information, because if as you say, column d contains text data such as RO, MO etc, then Excel can't perform a calculation such as MO*70 ?

Jan 16, 2008 | Microsoft Excel for PC

Assuming you are in Excel or another spreadsheet application.

To multiply cell A1 by cell B1 with product in cell C1, type in cell C1: =A1 * B1

Hope this helps.

To multiply cell A1 by cell B1 with product in cell C1, type in cell C1: =A1 * B1

Hope this helps.

Dec 05, 2007 | Computers & Internet

Mar 01, 2014 | Apple MacBook Air

1,114 people viewed this question

Usually answered in minutes!

×