Question about Microsoft Computers & Internet

Ad

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.

Posted on Aug 08, 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

Put 70 in for F, and apply BEDMAS, the order of operations, brackets, exponents, division and multiplication, and finally addition and subtraction. In this case, we have to do the brackets first before the multiplication and division. The answer should be 21 degrees Celsius.

Feb 24, 2015 | Office Equipment & Supplies

Put 70 in for F, and apply BEDMAS, the order of operations, brackets, exponents, division and multiplication, and finally addition and subtraction. In this case, we have to do the brackets first before the multiplication and division. The answer should be 21 degrees Celsius.

Feb 24, 2015 | Office Equipment & Supplies

When you perform an arithmetic operation such as addition, subtraction, multiplication, or division the result has a specific name. The result of addition is called the** sum;** the result of a subtraction is called the **difference**; the result of multiplication is the **PRODUCT**. Finally the result of a division is the **quotient**.

Apr 21, 2013 | Office Equipment & Supplies

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

did you say

6-(-9)=15

then it is true as negative multiplied by negative is always positive.

Also multiplication comes first than addition.

Hey, here is a FREE tip. Do you need to memorize the order of priority of these function then learn B O D M A S

(Bracket of Division Multiplication Addition Subtraction).

6-(-9)=15

then it is true as negative multiplied by negative is always positive.

Also multiplication comes first than addition.

Hey, here is a FREE tip. Do you need to memorize the order of priority of these function then learn B O D M A S

(Bracket of Division Multiplication Addition Subtraction).

Sep 07, 2010 | Vivendi [email protected] Mathematics Study Skills...

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

Ist I want to know what type of formulas u use in works

Jan 13, 2009 | Computers & Internet

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

Oct 01, 2019 | Microsoft Computers & Internet

311 people viewed this question

Usually answered in minutes!

hi thank you for ur explanation... pls help me what if i multiply,divide, add and subtract like this

multiply A1 UP TO A5 HOW TO DO IT?

DIVE A1 UP TO A5 ?

ADD A1 UP TO A5 ?

ETC.....

THANKS A LOT IM HOPING UR RESPONCE

×