Subtract Numbers in Spreadsheet

To subtract two or more numbers in a spreadsheet,
Step 1: First click on the cell where you want the answer to be given.
Step 2: Type = and click on the required cell reference and separate it with the minus symbol.
Step 3: Press the Enter key on the keyboard.
Example: If you want to subtract the value "1045" which is in cell A2 and "343" which is in cell A6, then you have to give it as =A2-A6

Related Topics

• How to add / sum of numbers in OpenOffice Spreadsheet?
• How to find average of numbers in OpenOffice Spreadsheet?
• How to add numbers using AutoSUM in OpenOffice Spreadsheet?
• How to find smallest number using MIN function in OpenOffice Spreadsheet?
• How to find largest number using MAX Function in OpenOffice Spreadsheet?

OpenOffice Spreadsheet Tutorial

• Introduction
• Spreadsheet Basics
  • Create File
  • Save File
  • Open File
  • Cell
  • Row
  • Column
  • Cell Reference
  • Enter String
  • Enter Numbers
  • Enter Date
  • Select Data
  • Edit Data
  • Moving One Cell to Another
  • Multiple Selections
  • Delete Data
  • Text Alignments
  • Font Color
  • Background Color
  • Bold Font Style
  • Italic Font Style
  • Font Size
  • Add
  • Subtract
  • Average
  • Autosum
  • MIN Function
  • MAX Function
  • Format Cells
  • Merge Cells
  • Cell Borders
  • Split Cells
  • Column Width
  • Date Format
  • Set Decimal Places
  • User Defined Date
  • Currency Format
  • Copy, Paste
  • Copy, Paste Formulas
  • Copy, Paste Column / Row
  • Copy, Paste Multiple Selections
  • Insert Row
  • Insert Column
  • Insert Hyperlink
  • Insert Image
  • Insert Chart
  • Rename Worksheet
  • Print
  • Cancel Printing
  • Page Preview
  • Print with Lines
  • Change Margins
  • Insert Header
  • Insert Footer
  • Insert Page Break
  • Delete Page Break
  • Change Header
  • Change Footer
  • Freeze Pane
  • Freeze Rows
  • Freeze Columns
  • Sorting
  • Filter Data
  • Standard filter
  • Advanced Filter
  • Remove Filter
  • Increment Number
  • Increment Date
  • Spell Check
  • Protect WorkSheet
  • Unlock Password Protected Sheets
  • Protect a Spreadsheet
  • Unlock Password Protected Documents

  Latest Tutorials

  • How To Install Softaculous In WHM CPanel
  • How To Enable IonCube Loader In WHM Panel
  • How To Add CNAME Record In Hioxindia Client Login?
  • How To Fix The WordPress 404 Error
  • How To Create Default WordPress .htaccess File
  • How To Leave A Copy Of Email Messages On Server
  • How To Establish Database Connection
  • How To Remove Redirection Using .htaccess
  • How To Access Webapps Folder Through FTP
  • How To Access Webapps Folder Through Terminal