Increase Value until Value in another cell reaches target

Could you attach a sample sheet with the desired results entered manually?

For how to attach workbooks at this forum check out the link provided in my signature below.

Have you tried Goal Seek?
https://support.office.com/en-us/art...rs=en-US&ad=US

If you want to change more than one input value - go for Solver https://support.office.com/en-us/art...b-f63e45925040

I used this formula in V2-

Please Login or Register  to view this content.

0.8392 can be calculated as follows-

First sum up factors of all variable costs
In our case, we have 0.1 and 0.034 as the factors for variable costs.

Summing then up we get 0.134
Now multiply this sum by tax factor i.e. 1.2 (20 %)
(Similarly if tax is 30% multiply by 1.3)

So we get 0.1608
Now subtract this from 1 to get 0.8392

Hope this makes it clear...

Regards
Sourabh

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. Why is it a rule?

1. It helps prevent massive confusion arising - which will happen if it is not clear which question is being answered.

2. The forum provides a public database for questions and answers. One thread = one question. Your problem will almost certainly be somewhat different.

So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.