excelpercentage
Based on a specific number, how to I work out the % increase required, using the % decrease which will be applied, to get back to that number?
Example:
$100 is the base number, but a deduction of 9% will be applied.
How do I calculate the % increase required from $100, in order to deduct 9% and get back to $100? I am looking for the calculation not the answer, as the % deducted will be variable.
I am using excel and would prefer in an excel formula if possible, but not necessary, the calculation to find the increase % is enough. thanks
Solution
You can use following formula to calculate the value.
Formula in Calculated Value cell i.e. C2 is:
=A2/(1-B2)
- How to border cells based on where the user click?
- Difference between running a userform in Visual Basic Editor (F5) and opening it with Show?
- VBA delete row working in one for loop but not another
- How to get HEX color value from cell color?
- Remove columns if the number of rows is less than a certain number using vba Excel
- VBA Security : my vbe password is well-set, but still can be hacked by a simple code
- Adjust vertical scrollbar range in Excel userform listbox
- Delete user ribbon from file
- Excel Hide/Show all tabs on Ribbon except custom tab
- Partial value font color in red using vba
- How do I conditionally append a row of Excel data from one sheet to another?
- Efficient formula or code to determine number of errors in range VBA
- Rank numbers including NA()s in Excel 365
- Is it possible to have a named range attached to "activesheet," rather than a specific sheet?
- How to calculate YoY Growth without a Date Field in Pivot?
- Excel hyperlinks 'Can't open specified file' on Mac
- Is it possible to dynamically change a cell/column reference in an excell formula based on another cell
- Excel - create a list from a data column but ignore/remove blank cells
- Split text string in Excel by semicolons and space
- Formula in Excel to count occurrences of substrings within strings
- find closed match value in matrix and return its row and column header in excel
- VBA to allow users to format cells on locked worksheet
- How can my For Each Loop loop to the next row?
- Excel - Return value based in two conditions
- Power Query, M language, Count items in a row with Special condition
- excel group column highlight matching values
- VBA - Save email object (OLEFormat) to file from clipboard
- excel vba projects not closing
- Excel VBA variable Chart Range
- Changing the Date Format for GROUPED dates in a PIVOT TABLE