Question about Microsoft Office Standard for PC

Re: excel

I hope I'm getting you right here. Type the following in column "D" =A1-20 Let me know if this helped.

Posted on Sep 06, 2007

If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

Word Password Recovery can really help you.

**Step1:** Free download Excel Password Recovery from wordpassword-recovery.com

**Step2: **Click "Open" to load the target protected Excel document.

**Step3:** Choose:100% instant
document decryption

Get it
from wordpassword-recovery.com

Jul 28, 2012 | Microsoft Office Word 2007 Full Version...

The easiest I can think of converting numbers into text in 2 colums is using a LOOKUP function in Excel. I have no knowledge of the range of numbers you are working with though so it may sound easier than it is...

Mar 25, 2009 | Apple Business & Productivity Software

You just have to use the subtraction formula. The formula is as follows:

=A1 - A2

Where A1 and A2 are cells that contain the data that you would like subtracted. If you want just two numbers subtracted you can type them directly:

=20 - 10

for more information look at the subtraction section of the following link.

http://www.homeandlearn.co.uk/ME/mes5p1.html

=A1 - A2

Where A1 and A2 are cells that contain the data that you would like subtracted. If you want just two numbers subtracted you can type them directly:

=20 - 10

for more information look at the subtraction section of the following link.

http://www.homeandlearn.co.uk/ME/mes5p1.html

Feb 11, 2009 | Microsoft EXCEL 2004 for Mac

Hmm interesting one...assuming all the words are all listed in colum A, I would recommend using a combination of ISNUMBER, CONCATENATE & multiple MID.

As I found it hard to describe the 3 formula sets, I decided to post a dummy file with an example here using some of the words you suggested (click in the download file button, the XLS file should load inmediatly).

Note: I made the example valid only for word up to a maximum of 20 characters long, but if you have longer words, just repeat on more columns.

__If the solution works for you, please rate my response__ :)

Cheers,

Ed

As I found it hard to describe the 3 formula sets, I decided to post a dummy file with an example here using some of the words you suggested (click in the download file button, the XLS file should load inmediatly).

Note: I made the example valid only for word up to a maximum of 20 characters long, but if you have longer words, just repeat on more columns.

Cheers,

Ed

Jan 19, 2009 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.

You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

Jul 29, 2008 | Microsoft Excel for PC

try to use this formula in excel.

=SUM(B1/A1)*100

=SUM(B1/A1)*100

Jul 27, 2008 | Microsoft Office Professional 2007 Full...

meri excel file ka security paasward missing. Pls i want track the paasward.

Jul 13, 2008 | Microsoft Excel for PC

Apr 25, 2014 | Microsoft Office Standard for PC

32 people viewed this question

Usually answered in minutes!

×