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?

Question 1

0helpful

2answers

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

0helpful

1answer

If function with array

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.

Apr 13, 2014 • Microsoft Excel for PC

1helpful

2answers

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.

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

0helpful

1answer

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

1helpful

1answer

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

0helpful

1answer

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

0helpful

1answer

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

0helpful

3answers

Formula

sumif

Jan 20, 2008 • Microsoft Excel for PC

0helpful

1answer

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

3helpful

1answer

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

Question 2

Anonymous

Expert 25 Answers
Posted on Mar 13, 2011

Anonymous

Expert

Joined: Mar 13, 2011

Answers

25

Questions

0

Helped

5894

Points

104

Shift + 8

Answer 2

Anonymous

Expert 192 Answers
Posted on Mar 13, 2011

Anonymous

Expert

Joined: Apr 12, 2010

Answers

192

Questions

1

Helped

64937

Points

457

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 (^ )

Related Topics:

Trustworthy Expert Solutions

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?

2 Answers

Anonymous

Anonymous

Add Your Answer

Attachments: Added items

Related Questions:

How to multiply in excel

If function with array

What are the formulas in grading the grades uisng microsoft excel

Steps to figure out formulas in excel

BASIC EXCEL FORMULA

Computer

Excel formula

Formula

Formula

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

Not finding what you are looking for?

MacBook Air

How to multiply in excel

Ask a Question

Check Out the Mobile Browsers Report

Top Apple Computers & Internet Experts

Paul Carew

Grand Canyon Tech

Paul Bade

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

Manuals & User Guides

Related Topics:

Trustworthy Expert Solutions

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?

2 Answers

Anonymous

Anonymous

Add Your Answer

Attachments: Added items

Related Questions:

How to multiply in excel

If function with array

What are the formulas in grading the grades uisng microsoft excel

Steps to figure out formulas in excel

BASIC EXCEL FORMULA

Computer

Excel formula

Formula

Formula

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

Not finding what you are looking for?

MacBook Air

How to multiply in excel

Related Topics

Ask a Question

Popular Questions

Sound - internal speakers (MacBook Air)

Macbook wont turn on, burning smell

Where is WPS button on MacBookAir?

Enter your system lock pin code to unlock this mac)

My sound in ichat is not working how can i fix it?

Check Out the Mobile Browsers Report

Top Apple Computers & Internet Experts

Paul Carew

Grand Canyon Tech

Paul Bade

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

Manuals & User Guides