subtracted

  1. S

    Automatic Subtraction

    Hi, I want to be able to input data which will automatically be subtracted from another number. For example, in cells E25 to E33, I want the input to be subtracted from 0.880. In cell E34 I want the input to be subtracted from 0.860. Does this have to be done by code? Thank you. :)
  2. A

    Excel Formula Best Practices

    I'm doing a training in the office where I am telling people about certain best practices. Chief among them is that instead of having a formula like this in E1: A1-B1+C1-D1, where all values are positive; they should have E1 be Sum(A1:D1) where B1 and D1 have negative values. That way the...
  3. M

    Subtracting from a cell

    Hi all, I'm kinda new to Excel Vba, and I'm making a very small project, so the thing is , I have a column (C) that has a header and a bunch of values under it, and what I need is that each time I enter a value in that column it will be subtracted from a specific cell (F1), it should be done...
  4. A

    Function for a given number of various subtractions?

    I need to create a function that will allow me to subtract a number P1 from an initial value, followed by this P1 being subtracted from the result RP1 times. Once P1 has been subtracted RP1 times, P2 must be subtracted RP2 times, and then P3 subtracted RP3 times until 0, which it will do as the...
  5. M

    Sum last X entries in a row

    Dear All, I’m pretty new to Excel and appreciate any guidance regarding the following issue that I encounter; In the following, I have a row of numbers; What I want to be in the second row is the sum of the last “X” number of elements; Meaning that for X=4, as long as the number of values in...
  6. I

    Complex Conditional Calculations

    hi, i want to add or subtract the value to the existing value of the cell, but the addition or subtraction would depend on various conditions and the cell in which data needs to be added or subtracted would also be dependent on the conditions, If you look at the picture my problem would be more...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top