subtract

  1. C

    Need IF statement but not sure how or which to use

    I need to determine if a cell is greater than a number then perform one calculation and if its less than then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it...
  2. C

    Need IF statement but not sure how or which to use

    I need to determine if a cell is greater than a number then perform one calculation and if its great then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it by...
  3. tourless

    Object Defined Error

    Hi Folks, I'm not sure why the following line of code fails... wsCustomerReportCard.Cells(10, LastRow(wsCustomerReportCard)).FormulaR1C1 = "=(8, LastRow(wsCustomerReportCard))-(9, LastRow(wsCustomerReportCard)" I'm simply trying to subtract with a last row reference as this included in a loop.
  4. P

    Subtract difference between B5 and B4, = D5

    I would like to subtract B5 - B4 putting result in D5, such as B5=322 and B4= 442 than 322 - 442 = D5.
  5. P

    Subtract number from column C4 and put result in D4

    After a number is written in column C4, i would like to subtract 1850 - (Number), such as C4=2000 than 1850 - 2000 = -150, the result would be in right column D4, D4=-150. The number 1850 would come first subtracted by Number, such as 1850-(number) resulting in D4.
  6. P

    Subtract number from left column

    I would like to subtract -10 from the left column, but only if the column is not empty and has a number. If left column G is 200 than H would be 190, If column G is empty than H would be empty.
  7. P

    Subtract number from left column

    I would like to subtract -10 from the left column, but only if the column is not empty and has a number. If left column G is 200 than H would be 190, If column G is empty than F would be empty.
  8. P

    Subtract a number according to Drop Down list options

    I would like to subtract a number according to Drop Down list options. My Drop Down list is in colums B4 to B20 and each column has the same tree options: A-B-C , and there are columns D4 to D20 and F4 to F20 each column with numbers in reference to those options. Columns G4 TO G20 are the...
  9. L

    Issue Subtracting Time

    Hello I want to get hours worked. I am using the below to formulas. The first one is just a straight Start Time - End Time but if that is over 30 minutes I want to use the second formula to subtract 30 minutes for Lunch. They both work but how do I put this into an iif statement. I cannot...
  10. C

    SumProduct Formula with subtraction function

    In column A I have hourly rates and in column B I have hours. At the bottom of the column, I have a sumproduct formula: =sumproduct(a1:a10,b1:b10) In one formula, can I maintain the sumproduct formula but add a function subtract a value, say $5.00, from every value in column A? I can't add...
  11. L

    Subtract Timestamps

    Hello, I am wondering how you can subtract timestamps looking something like this: <tbody> <tbody> 2018-03-19 14:34:54 </tbody> <tbody> 2018-03-20 09:34:48 </tbody> <tbody> 2018-03-19 14:50:24 </tbody> <tbody> 2018-03-20 09:34:45 </tbody> </tbody> If I subtract...
  12. F

    Subtracting the value of one cell from another, and hve it rtain the new value

    Need a formula or macro that will allow me enter a 1 into a cell, on sheet1, lets say B2, and subtract it from a cell H3 on sheet2. Sheet2 H3 =10. When I enter the 1 it should subtract the 1 from the 10, and make H3=9, and when I do it again, the value of H3 will be 8, and so on till it reaches...
  13. D

    HOW can I subtract sumif

    how can I subtract the end time from the start time. when I run what I thought would work below it gives me an error for using that (-) symbol =SUMIF(Table3[[Host]:[Participant11]],'Employee Table'!$A2,Table3[[EndTime]-[StartTime]])
  14. L

    Power Query Date Field to Subtract 4 Hours

    In Power Query, I have a Date field and would like to subtract 4 hours from each date/time value in a custom column. For example, I want to subtract 4 hours from 2/7/2018 2:44:12 AM which should return 2/6/2018 10:44:12 PM. How can I do this? What function do I need to use in the custom...
  15. Y

    Find Cells that equal a certain amount

    Hey everyone, I have a list of about 50-60 values when added up don't equal (and it's suppose to equal) another value, rather they add up to a value smaller. SO, I'm trying to figure out which positive and negative values add (or in this case subtract) to the missing value. I've been searching...
  16. M

    Formula to subtract one cell from total

    Hi, I'm not a regular user of Excel but I need a formula to sum a column of figures and subtract another cell value ie: =SUM(E1:E10)-A10 . I've tried this but it doesn't work, any help please
  17. D

    Subtract Previous Cell's Value from LOOKUP Result

    Hello, I have several rows with dates several dates in each column marking milestones of a task. Using LOOKUP, I have identified the last cell with a date within it and displayed the date using the following formula: =LOOKUP(2,1 / (ISNUMBER(A1:G1)),A1:G1) Is there a formula I can use to...
  18. ironsides

    Formula adjustment

    This formula below is correct as it stands the Col AB range is .10 :999.99 I want to adjust this formula to include subtract 10:19.99 =SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99") ( the sum of Col AB : Add .10 to 9.99 subtract 10 to 19.99 add 20 to...
  19. E

    Need help writing a MAX IF function

    I am a professed excel noob and so I need help writing this function. I need to write a function where a column of values will subtract from an original value until the value reaches zero. If my original value is 125, I need the following table to look like this <tbody> B1 20 B2 20 B3...
  20. L

    Find newest Time and oldest Time from a cell with many times separated by a comma and subtract them

    Hello, I have cells that looks something like what is shown in column 1. I want to tell excel "Find the newest time (ie 12:07:35) and the oldest time (ie 12:07:33). So two formulas here. Then I want to subtract them. <tbody> <colgroup><col></colgroup><tbody>...

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