Notices
Results 1 to 3 of 3

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,574
    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  
     

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
  •