Question about Microsoft Excel for PC

# 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

• 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.

Scholar:

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

• Expert

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

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What percent is R3800 of R20859.11 and what is the formula to work it out?

R3800 is 18.22% of 20859.11

Here is the formula 3800 divided by 20859.11 multiplied by 100 = 18.2175%

vise vesa

18.2175 divided by 100 multiplied by 20859.11 = 3800

Aug 26, 2013 | Computers & Internet

### =((I42*0.95)*0.75)*0.07783176 How is this calculated, please explaine step by step

it the cell which contains this formula looks at the contents of cell L42 and multiplies it by 0.95 this result is then multiplied my .75 then this total is multiplied by .07783176

May 09, 2011 | Computers & Internet

### I need the formula to solving all percentage problems

Are you speaking of a problem like: "What is 25% of 50?"?
What you would do is: 1 x 50 which is 100% of 50. You need 25% of 50, so you will multiply 50 x .25 (.25 represents 25%). Then you will find your answer (In this case, 12.5).

Feb 28, 2011 | Office Equipment & Supplies

### The temp reading is in celcius how do i change to fahrenheit?

From Celcius the formula is Deg. C divided by 5 multiply by 9 and plus 32.

From Fahrenheit the formula is Deg F minus 32 divide by 9 multiply by 5.

Feb 23, 2011 | 1996 Buick Park Avenue

### 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

### Help

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

Jul 22, 2008 | Microsoft Excel for PC

### 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 | Computers & Internet

### Excel Formula

Use Edit copy and higlight as many rows as you need

Sep 06, 2007 | Microsoft Office Standard for PC

#### Related Topics:

86 people viewed this question

Level 3 Expert

Level 3 Expert