0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Using the Goal Seek feature



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.

0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!