Question about Microsoft Excel for PC

Ad

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

Ad

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

Ad

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

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

Tc = (5/9)*(Tf-32); Tc = temperature in degrees Celsius, Tf = temperature in degrees Fahrenheit.

Jun 03, 2011 | Kitchen Ranges

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

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

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

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.

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

Feb 23, 2011 | 1996 Buick Park Avenue

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)

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

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

Jul 22, 2008 | Microsoft Excel for PC

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.

=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

Use Edit copy and higlight as many rows as you need

Sep 06, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

86 people viewed this question

Usually answered in minutes!

×