Notices
Results 1 to 7 of 7

Thread: Excel Basic Formulas

  1. #1 Excel Basic Formulas 
    Suspended
    Join Date
    Nov 2017
    Posts
    2
    What are the Formulas of adding , Subtracting if I want to Apply in Excel?


    Reply With Quote  
     

  2.  
     

  3. #2  
    Bullshit Intolerant PhDemon's Avatar
    Join Date
    Feb 2013
    Location
    Newcastle-upon-Tyne, UK
    Posts
    4,918
    If you are simply adding two cells together you can just use the + symbol between the cell locations. If there are a lot you can use the SUM function e.g. SUM(A1:A8) will add together all of the numbers in the cells between A1 and A8. For subtraction use the - sign. As there is no subtract function in Excel a work around is to put a - sign in front of the numbers in the cells and use the SUM command.


    Reply With Quote  
     

  4. #3  
    Forum Freshman
    Join Date
    Oct 2017
    Posts
    74
    cell A1:number,cell B1:number, C1:result
    select C1, type =, select A1, type +, select B1, click enter

    cells A1:A10 numbers, cells B1:B10 numbers, C1:C10 results
    apply 1st method for C1
    select C1, click ctrl and c, click&drag C2:C10, click ctrl and v

    cell A1 number, cells B1:B10 numbers, C1:C10 results
    apply 1st method for C1
    modify the description in formula editor (above worksheet,textbox on rightside of Fx) change C1 by $C$1

    cells A1:A10 numbers, A11 result
    click A11, type sum( ,click & drag A1:A10, type ), click enter
    Reply With Quote  
     

  5. #4  
    Suspended
    Join Date
    Feb 2018
    Posts
    7
    Add the values in a column or row by using a button. You can use AutoSum to quickly sum a range of numbers in a column or row. Click an empty cell below a column of numbers or to the right of a row of numbers, and then click AutoSum. Excel selects what it determines to be the most likely range of data....
    Reply With Quote  
     

  6. #5  
    Suspended
    Join Date
    Feb 2018
    Posts
    7
    One of the easiest method using formulae that will minimize the consumption of time to do addition and subtraction..
    Reply With Quote  
     

  7. #6  
    Forum Isotope
    Join Date
    Feb 2012
    Location
    Western US
    Posts
    2,795
    Quote Originally Posted by Patricia Riffle View Post
    One of the easiest method using formulae that will minimize the consumption of time to do addition and subtraction..
    You might wish to take note of the fact that the OP asked this question a half-year ago or so and that she was also banned.
    Reply With Quote  
     

  8. #7  
    Suspended
    Join Date
    Oct 2018
    Location
    Australia
    Posts
    1
    I am looking for this thanks.
    Reply With Quote  
     

Similar Threads

  1. Excel question
    By Shaderwolf in forum Computer Science
    Replies: 16
    Last Post: September 4th, 2013, 02:02 PM
  2. MS excel VS origin
    By bobby2009 in forum General Discussion
    Replies: 0
    Last Post: March 29th, 2010, 02:43 AM
  3. Excel graph
    By Lightz in forum General Discussion
    Replies: 0
    Last Post: February 25th, 2010, 03:58 PM
  4. Excel, VBA
    By Rhapsody_ in forum Computer Science
    Replies: 1
    Last Post: November 25th, 2009, 10:05 AM
  5. Excel speed problem
    By newnothing in forum Computer Science
    Replies: 0
    Last Post: March 1st, 2009, 02:45 AM
Bookmarks
Bookmarks
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •