Question about Computers & Internet

1 Answer

How do I create an Excel formula to subtract within a column, row by row?

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Computers & ... Master
  • 3,477 Answers

Put in result row
=A1-A2

or = A1-A2-A3

A being the column
the numbers 1 2 3 are the rows
or go to result cell type =
then click on cell then press -
then click on cell to minus then press -
the click on next cell to minus

Posted on Dec 08, 2016

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do i subtract two cells and progress down a row by a day so the next day the formula subtracts the current day and previous day?


You have to start the sequence with a slightly different formula because there is no preceding value for Monday.
25525374-qztzwsd5tae24twsq5kxbvm0-3-0.jpg The rest of the formulas are running totals so they are the same just dynamically duplicated down the column add infinitum.
25525374-qztzwsd5tae24twsq5kxbvm0-3-2.jpg Just duplicate the the formula Picking up the value form the result column and subtracting the next running subtraction value.

Mar 06, 2015 | Microsoft Excel 2010

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    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

    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

    1 Answer

    Excel formula


    I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

    Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

    Now click back to Sheet1 where your data is and in A2 put this formula:
    =VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)
    Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

    You can copy and paste this formula down the column to calculate your other values.

    Hope that helps!
    Terry

    Aug 30, 2008 | Microsoft Excel for PC

    1 Answer

    Computer


    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.

    Aug 08, 2008 | Microsoft Computers & Internet

    3 Answers

    EXCEL FORMULA PC


    The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

    C2 = A2 & B2
    C3 = A3 & B3
    C4 = A4 & B4
    etc.

    Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

    Hope this helps.

    May 27, 2008 | Microsoft Excel for PC

    2 Answers

    Display calculation result in a previous cell


    Look into the =SUMIF function, it sounds like this may be what you are looking for.

    Hope this helps!

    Apr 09, 2008 | Microsoft Excel for PC

    1 Answer

    Lookup,s


    If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
    To do this, do the following:
    1) Move the C Column to be the A Column, shifting all other columns to the right.
    2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
    3) Use A1 as your search field.
    4) In A2, enter the following formula:
    =VLOOKUP($A$1,$A$2:$C$6,3,)

    Describing above parameters, in the formula:
    $A$1 -> the search field (name your looking for).
    $A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
    3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

    If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
    Also, if you can sort column A (names) it would find results faster, if your data set is large.

    Feb 03, 2008 | Microsoft Excel for PC

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    30 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Doctor PC
    Doctor PC

    Level 3 Expert

    7733 Answers

    kakima

    Level 3 Expert

    102366 Answers

    David Payne
    David Payne

    Level 3 Expert

    14161 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...