Dynamic Subtraction formula in excel sheet

0 votes

In order to dynamically subtract cells from one another within the same column, I need to create a formula in Excel.

For example, A2 = A1 - G1 (G column is fixed)

    and  A3    =     A2   -    G2
   
    and  A4    =     A3   -    G3
Jan 5 in Others by Kithuzzz
• 28,900 points
65 views

1 answer to this question.

0 votes

Excel is capable of using both a relative reference to the current cell and a dynamic reference. For instance, if you enter =A1-G1 in cell A2 and drag this cell down using the square, all subsequent cells in column A will immediately receive the same formula.

Video example: Copy cells and keep formulas relative to current cell

answered Jan 6 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 53,520 points
242 views
0 votes
1 answer
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 53,520 points
99 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 53,520 points
68 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
215 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
395 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
177 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 53,520 points
75 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

answered Jan 31 in Others by narikkadan
• 53,520 points
47 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP