Question about Microsoft Excel for PC

1 Answer

Formula column d contains information such as RO, MO, XO and I need a formula that allows me to all RO multiplied by 70@ : all MO multiply by 50@

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert whose answer gotĀ voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers
Re: 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 ?

Posted on Jan 19, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

2 Answers

Excel farmulas

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif($A$1:$A$7000;F1;$D$1:$D$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

1 Answer

I need help with the "if/then" formula on microsoft words spreadsheet

A B C D E F 5 TRUE 5 TRUE 5 TRUE 6 3 6 3 6 3 red blue red blue 27 blue

If :-

It will show the resuls 30.

Above table shows if A3 is less than or equal to 7 then A3 should multiply by 5 otherwise result zero. Therefore A3 in this table is less 7 then hence it has multiplied by 5 so result would be 30.

Jan 20, 2009 | Microsoft Office 2003 Basic Edition...

1 Answer

% problems

You need to divide by three and multiply by .01 which will give you the average percetage or you need to divide the total by each entry and get invidual percentages

Dec 02, 2008 | Microsoft Business & Productivity Software

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

2 Answers


go to page setup and under scaling you can adjust to your required percentage

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

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

Excel Formula

Use Edit copy and higlight as many rows as you need

Sep 06, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

84 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

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

Answer questions

Manuals & User Guides