About 6,910 results
Open links in new tab
  1. Formula to subtract a percentage in total - MrExcel

    Sep 27, 2013 · I have made a simple receipt form in Excel, but am having a bit of difficulty subtracting a percent off the total. I can get the cell to subtract a percent, but I don't want it to do it all the time.

  2. Multiple Discounts for a Value | MrExcel Message Board

    Dec 28, 2017 · Hi Folks, I am wondering if there a pre-existing excel formula to subtract multiple percentages for a certain value. For example, imagine you are offering a product which has several …

  3. Subtracting percentage from a sum of Cells - MrExcel

    May 12, 2014 · Welcome to the board. Instead of Subracting the percentage, you can multily the result by that %'s opposite % Basically, 100% minus the percent you want. To subtract 10 percent, 100% - …

  4. Subtracting Percentages Issue | MrExcel Message Board

    Jun 16, 2008 · Hey all! I know this is very minor but I can't seem to remember this...I want to subtract two percentages but get a value in the value field instead of a percent. Example: 18.1% - 18.7% = …

  5. How to Add Cells then Divide by that Total in the Same Cell

    Oct 13, 2016 · Hi All! I'm sorry if this has been in a previous post, I could not find what I was looking for. I need help with what probably is a simple formula... I need to Sum Cells A1 and A2, then divide that …

  6. Percentages in VBA | MrExcel Message Board

    Oct 13, 2007 · I'm trying to make a macro that will add or subtract a user inputted percentage to selected cells. It is easy enough if the user inputs a value but 5% is...

  7. Formula to calculate difference between 2 #'s - MrExcel

    Apr 14, 2003 · I am trying to get excel to calculate the difference between two cells. The fields contain $ amounts. Column A is 2002 daily sales figures. Column B is 2003 daily sales fig's. I need excel to …

  8. Adding a plus or minus sign into a formula that shows the difference ...

    Aug 4, 2017 · Hello, I would like some help with a formula that tells me the difference between numbers in two cells but does so with a + or – sign depending on whether the number is lower than or higher …

  9. Counting Remainder from division and subtraction - MrExcel

    Nov 28, 2010 · Problem 2: How does Excel figure out the last percentage constant to be used to multiply with the remaining hours of the last time box? The last time box will have a logical value of <=4. In …

  10. percentage split | MrExcel Message Board

    Apr 23, 2008 · I have the following cells: A1: the percentage difference between cost1(D1) and cost2(C1) B1: total product cost (C1+D1) I need a formula that no matter if the %diff increases or …