Question about Business & Productivity Software

1 Answer

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

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 26 Answers
Re: Multiply a figure in one cell times a figure in...

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.

Posted on Dec 06, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

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

I am trying to figure out a payroll formula. I

Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:


Column A Column B
Total 40 OverTime 2

Formula in this cell where 40 is at:

Formula in cell where 2 is at:

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

I want to know how I can to apply the formula where the excell find one data and multiply for one data of other cell, what formula can I apply for my question?

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

1 Answer

Setting a Formula

You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer


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 Business & Productivity Software

1 Answer


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

2 Answers

Excel 2002 formula

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Business & Productivity Software

1 Answer

Getting the excel formula

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.

Nov 15, 2007 | Business & Productivity Software

3 Answers

Excel Formula

columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

656 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18259 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides