Question about Microsoft Office Standard for PC

Ad

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

Ad

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

You'll need to use the Order of Operations to solve this problem. They are Parenthesis, Exponents, Multiplication, Division, Addition, Subtraction (Please Excuse My Dear Aunt Sally). Multiplication/Division have the same weight, so you read it from left to right. Same with Addition/subtraction.

For this problem, you see there are no parenthesis or exponents, so you move right to multiplication/division. Reading from left to right, the first thing you see is 240/20. Evaluating that comes out to 12. Now you have 12*6 (assuming the x is a multiplication symbol), which evaluates to 72. 72-13=59, and 59+41=100.

Written another way:

240/20*6-13+41

12*6-13+41

72-13+41

59+41

100

For this problem, you see there are no parenthesis or exponents, so you move right to multiplication/division. Reading from left to right, the first thing you see is 240/20. Evaluating that comes out to 12. Now you have 12*6 (assuming the x is a multiplication symbol), which evaluates to 72. 72-13=59, and 59+41=100.

Written another way:

240/20*6-13+41

12*6-13+41

72-13+41

59+41

100

Aug 29, 2011 | Computers & Internet

Big calculators work a little different than handheld calculators. Like the above commentor explained, if you have a basic "whats 100 minus 20?" You have to entered as 100 + 20 -- And when you hit the minus button at the end, it will give you the total. 100 is the positive number, and the 20 is the negative number that your subtracting. Also you can hit 20 -- 100 + and get the same total because you entering 20 as the negative and 100 as the positive, just in reverse.

Jul 27, 2009 | Casio HR-100TEPlus Calculator

whatever the software might be.. excel or word.. just select the columns.. right click.. do whatever you want.. you'll do the needful if you can read and understand english.. its very siiiiiiiimmmmppppllle..

Mar 09, 2009 | Microsoft Windows XP Home Edition

From the manual:

Function: Keys

Answer

Percentage: 100 x 5% 100 x 5 % 5

Add On: 100 + (100 x 5%) 100 x 5 % + 105

Discount:10 - (10 x 20%) 10 x 20 % - 8

Ratio: 30 = 60 x ?% 30 (division key) 60 % 50

% change: 12 = 10 + (10 x ?%) 12 - 10 % 20

Mark-up: 25% mark-up of 120 120 = 25% 160

- 40 (profit)

Function: Keys

Answer

Percentage: 100 x 5% 100 x 5 % 5

Add On: 100 + (100 x 5%) 100 x 5 % + 105

Discount:10 - (10 x 20%) 10 x 20 % - 8

Ratio: 30 = 60 x ?% 30 (division key) 60 % 50

% change: 12 = 10 + (10 x ?%) 12 - 10 % 20

Mark-up: 25% mark-up of 120 120 = 25% 160

- 40 (profit)

Mar 03, 2009 | Casio MS-80TV Scientific Calculator

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

With an adding machine, which is what this is, you enter the number followed by the + or -. If you wanted to add 10+20, you would enter 10 then + then 20 then +. This would show your answer. If you are using the printer and you wish to see the final answer on the paper, hit the * key and your answer will print.

If you are subtracting, let's say 100-40, you would enter 100 then + then 40 then - then *. Adding machines expect you to enter long strings of numbers to total. You may have both positive and negative numbers. So, you always enter the number first followed by either positive + or negative -.

You might have 100 + 25 - 37 - 1 + 50. For that enter:

100+25+37-1-50+ then *

Different than a calculator but the same for all "adding machines". This machine should really be called an adding machine since that is the kind of input it is looking for.

If you are subtracting, let's say 100-40, you would enter 100 then + then 40 then - then *. Adding machines expect you to enter long strings of numbers to total. You may have both positive and negative numbers. So, you always enter the number first followed by either positive + or negative -.

You might have 100 + 25 - 37 - 1 + 50. For that enter:

100+25+37-1-50+ then *

Different than a calculator but the same for all "adding machines". This machine should really be called an adding machine since that is the kind of input it is looking for.

Jan 13, 2009 | Canon P23-DHV Calculator

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

try to use this formula in excel.

=SUM(B1/A1)*100

=SUM(B1/A1)*100

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

Aug 20, 2013 | Microsoft Office Standard for PC

36 people viewed this question

Usually answered in minutes!

×