A few words of thanks would be greatly appreciated.

Excel - Using the Goal Seek feature

Latest update on August 30, 2012 at 09:31 AM by deri58 .

You have made an estimate in the form of an Excel table:

you have added each sub-totals and get a total HT (in E8 for example), followed by a discount (in E9), the VAT applied (E10), got your Total Price VAT included .(E11)
your client asks you to round the tax amount ..... (in E11)

Criteria:

You do not want to change your Total HT (E8).
You may not edit your VAT applied (E10).
You can change your Discount (E9).

Go to: Tools > Goal seek > Select cell .. Clicking E11 (your Total TTC)/Value to reach ... you specify the value you want to be displayed ... Click on E9 (Discount) .... OK.

Excel recalculates the discount (E9) to reach precisely exact final value (E11), and also adjusts your VAT amount (E10) without changing the rate.

Excel - Using the Goal Seek feature
Excel - Disable the Fill handle feature - How-To - Excel
Disable the Auto Recover Feature for a Specific Workbook in Excel - How-To - Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Sorry this feature is currently unavailable tik tok ✓ - Forum - Facebook
Transfer data from one excel worksheet to another automatically - How-To - Excel

This document, titled « Excel - Using the Goal Seek feature », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Excel/VBA - the Boggle game

Nesting More Than 7 IF Statements in an Excel Function

Subscribe To Our Newsletter!