subtract

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...

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.

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

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.

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.

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.

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...

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...

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...

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...

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...

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]])

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...

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...

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

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...

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...

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...

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>...

I am looking to subtract 15 minutes from whatever value is in cell O2 and put that information in P2. Any help would be appreciated.