Question about Microsoft Computers & Internet

1 Answer

Computer what is the formulas of division,subtraction and multiplication in ms excel?

Posted by faudz on

  • ayagil Dec 01, 2008

    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

×

Ad

1 Answer

Anonymous

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 4 Answers

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

  • Anonymous Aug 08, 2008

    Sorry, the second example of subtraction should have said "Subtract", not "Add", as in "Subtract the contents of cell A1 from the contents of cell B1: =B1-A1"

×

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to convert Fahrenheit to Celsius


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

1 Answer

Convert Fahrenheit to Celsius 70F to C by applying the formula (F-32)*5/9


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

1 Answer

What does poduct mean in maths


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

2 Answers

What are the formulas in grading the grades uisng microsoft excel


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.

  1. All formulas begin with an equals sign (=).
  2. 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.
  3. 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.
  4. 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.
  5. 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

1 Answer

Explain 6--9=15


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

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

1 Answer

Sir i want know about the basic of the excel $ how to use thw formula of plus and minus plz rply me Thank you Regards shambhu pandey


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

Aug 03, 2010 | Microsoft Excel for PC

3 Answers

Ms-office


Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
  1. =A1-A2
  2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

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

2 Answers

Wanted to learn "ALL" formulas of MS Office Excel - please guide


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

Jan 13, 2009 | Computers & Internet

1 Answer

BASIC EXCEL FORMULA


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

Sep 29, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?

Open Questions:

0 Answers

KYOCERA PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change KYOCERA PRINTER customer care rKYOCERA PRINTER via phone number 1800 828 0294 just follow some steps to recover KYOCERA PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure KYOCERA PRINTER with KYOCERA PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rKYOCERA PRINTER KYOCERA PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rKYOCERA PRINTER KYOCERA PRINTER customer care to rKYOCERA PRINTER or change it quickly, if you have any of them so contact to get well KYOCERA PRINTER care form us. KYOCERA PRINTER customer care rKYOCERA PRINTER not working XEROX PRINTERcustomer care rKYOCERA PRINTER phone number KYOCERA PRINTER customer care rKYOCERA PRINTER contact number KYOCERA PRINTER customer care rKYOCERA PRINTER help KYOCERA PRINTER customer care rKYOCERA PRINTER care KYOCERA PRINTER customer care rKYOCERA PRINTER wont work KYOCERA PRINTER customer care rKYOCERA PRINTER wont work KYOCERA PRINTER customer care rKYOCERA PRINTER link KYOCERA PRINTER customer care rKYOCERA PRINTER issues KYOCERA PRINTER customer care rKYOCERA PRINTER usa KYOCERA PRINTER customer care rKYOCERA PRINTER customer care service. XEROX PRINTERemail account customer care rKYOCERA PRINTER ' free KYOCERA PRINTER email customer care care ' cannot rKYOCERA PRINTER KYOCERA PRINTER email customer care ' KYOCERA PRINTER email customer care care ' KYOCERA PRINTER email customer care care download ' KYOCERA PRINTER email customer care care software ' free KYOCERA PRINTER email customer care care . KYOCERA PRINTER email customer care change, KYOCERA PRINTER email hacked customer care changed, KYOCERA PRINTER email hacked can't change customer care, change KYOCERA PRINTER email customer care on iphone, change KYOCERA PRINTER email customer care on ipad, change KYOCERA PRINTER email customer care on android, KYOCERA PRINTER email account hacked can't change customer care, how to change KYOCERA PRINTER email customer care on droid, KYOCERA PRINTER email customer care problems, KYOCERA PRINTER email customer care not working, KYOCERA PRINTER email account customer care rKYOCERA PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

0 Answers

TOSHIBA PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change TOSHIBA PRINTER customer care rTOSHIBA PRINTER via phone number 1800 828 0294 just follow some steps to recover TOSHIBA PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure TOSHIBA PRINTER with TOSHIBA PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rTOSHIBA PRINTER TOSHIBA PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rTOSHIBA PRINTER TOSHIBA PRINTER customer care to rTOSHIBA PRINTER or change it quickly, if you have any of them so contact to get well TOSHIBA PRINTER care form us. TOSHIBA PRINTER customer care rTOSHIBA PRINTER not working XEROX PRINTERcustomer care rTOSHIBA PRINTER phone number TOSHIBA PRINTER customer care rTOSHIBA PRINTER contact number TOSHIBA PRINTER customer care rTOSHIBA PRINTER help TOSHIBA PRINTER customer care rTOSHIBA PRINTER care TOSHIBA PRINTER customer care rTOSHIBA PRINTER wont work TOSHIBA PRINTER customer care rTOSHIBA PRINTER wont work TOSHIBA PRINTER customer care rTOSHIBA PRINTER link TOSHIBA PRINTER customer care rTOSHIBA PRINTER issues TOSHIBA PRINTER customer care rTOSHIBA PRINTER usa TOSHIBA PRINTER customer care rTOSHIBA PRINTER customer care service. XEROX PRINTERemail account customer care rTOSHIBA PRINTER ' free TOSHIBA PRINTER email customer care care ' cannot rTOSHIBA PRINTER TOSHIBA PRINTER email customer care ' TOSHIBA PRINTER email customer care care ' TOSHIBA PRINTER email customer care care download ' TOSHIBA PRINTER email customer care care software ' free TOSHIBA PRINTER email customer care care . TOSHIBA PRINTER email customer care change, TOSHIBA PRINTER email hacked customer care changed, TOSHIBA PRINTER email hacked can't change customer care, change TOSHIBA PRINTER email customer care on iphone, change TOSHIBA PRINTER email customer care on ipad, change TOSHIBA PRINTER email customer care on android, TOSHIBA PRINTER email account hacked can't change customer care, how to change TOSHIBA PRINTER email customer care on droid, TOSHIBA PRINTER email customer care problems, TOSHIBA PRINTER email customer care not working, TOSHIBA PRINTER email account customer care rTOSHIBA PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

0 Answers

EPSON PRINTER Customer care Phone nUmber+1800 828 0294 Get easy steps to forgot or change EPSON PRINTER customer care rEPSON PRINTER via phone number 1800 828 0294 just follow some steps to recover EPSON PRINTER customer care while you want. In varoius conditions many people lost their account customer care and much more secure information or information may be hacked by anyone so in that case people want to configure EPSON PRINTER with EPSON PRINTER or other microsoft account services. Their are many certified officer to suggest people that how to change or rEPSON PRINTER EPSON PRINTER voicemail customer care using phone number in easy mode wih simple procedure. Hence search engine suggest many combinations to rEPSON PRINTER EPSON PRINTER customer care to rEPSON PRINTER or change it quickly, if you have any of them so contact to get well EPSON PRINTER care form us. EPSON PRINTER customer care rEPSON PRINTER not working XEROX PRINTERcustomer care rEPSON PRINTER phone number EPSON PRINTER customer care rEPSON PRINTER contact number EPSON PRINTER customer care rEPSON PRINTER help EPSON PRINTER customer care rEPSON PRINTER care EPSON PRINTER customer care rEPSON PRINTER wont work EPSON PRINTER customer care rEPSON PRINTER wont work EPSON PRINTER customer care rEPSON PRINTER link EPSON PRINTER customer care rEPSON PRINTER issues EPSON PRINTER customer care rEPSON PRINTER usa EPSON PRINTER customer care rEPSON PRINTER customer care service. XEROX PRINTERemail account customer care rEPSON PRINTER ' free EPSON PRINTER email customer care care ' cannot rEPSON PRINTER EPSON PRINTER email customer care ' EPSON PRINTER email customer care care ' EPSON PRINTER email customer care care download ' EPSON PRINTER email customer care care software ' free EPSON PRINTER email customer care care . EPSON PRINTER email customer care change, EPSON PRINTER email hacked customer care changed, EPSON PRINTER email hacked can't change customer care, change EPSON PRINTER email customer care on iphone, change EPSON PRINTER email customer care on ipad, change EPSON PRINTER email customer care on android, EPSON PRINTER email account hacked can't change customer care, how to change EPSON PRINTER email customer care on droid, EPSON PRINTER email customer care problems, EPSON PRINTER email customer care not working, EPSON PRINTER email account customer care rEPSON PRINTER.

Apr 04, 2019 | Microsoft Computers & Internet

Computers & Internet Logo

Related Topics:

326 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...