Question about Apple MacBook Air

2 Answers

How to find the star key for multiplying in a formula? Like 2 times 3, how i can find the star key to type in the formula in excel?

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 25 Answers

Shift + 8

Posted on Mar 13, 2011

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

  • Expert
  • 192 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How to multiply in excel


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

Nov 11, 2016 | Computers & Internet

3 Answers

Can't see coordinates in Excel Formulas


And this is when you have selected a box and simply type something ?

Dec 28, 2007 | Computers & Internet

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

1 Answer

Steps to figure out formulas in excel


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.

Sep 30, 2009 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


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

Sep 29, 2008 | Microsoft Computers & Internet

1 Answer

Computer


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.

Aug 08, 2008 | Microsoft Computers & Internet

1 Answer

Excel formula


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.

Feb 27, 2008 | Computers & Internet

1 Answer

Formula


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

1 Answer

Multiply a figure in one cell times a figure in another cell , need formula


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.

Dec 05, 2007 | Computers & Internet

Not finding what you are looking for?
Apple MacBook Air Logo

1,099 people viewed this question

Ask a Question

Usually answered in minutes!

Top Apple Computers & Internet Experts

paulcarew

Level 3 Expert

2460 Answers

Martin Buck
Martin Buck

Level 2 Expert

82 Answers

Paul Bade

Level 3 Expert

1536 Answers

Are you an Apple Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...