Question about Microsoft Excel for PC

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

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

=if(A3<=7;A3*5;0)

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.

If :-

=if(A3<=7;A3*5;0)

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

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

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:

COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

Example The final formula is like:

COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

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

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.

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

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

Jul 22, 2008 | Microsoft Excel for PC

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.

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

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

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

84 people viewed this question

Usually answered in minutes!

×