# Finding unknown value

1. ## Finding unknown value

I'm having trouble trying to find an unknown value for a spreadsheet. Maybe there is some formula that can help me?

C1=B1/A1
C2=B2/A2
etc...

A5=SUM(A1:A4)
B5=SUM(B1:B4)
C5=SUM(C1:C4)

I want to have C6 show how much "B" column to subtract to get the value I want (15%) in C5. Maybe C5 says 64%, but I need to know if I want C5 to equal 15%, then I need to subtract "X".

2. ## Re: Finding unknown value

Hi Visigoth and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

3. ## Re: Finding unknown value

Ok, I appreciate the advice. I've attached a workbook that is a little different than my description. In the workbook I'm trying to get F12 to equal the amount of "# of waivers" needed to be subtracted to get the total "% of waivers" down to 15%. I can manually figure it out, but if I could understand a formula that makes it automatic, it'd greatly reduce working time. My "formula knowledge" is pretty limited.

4. ## Re: Finding unknown value

Well one problem is that total% is not additive. You need to calculate total waivers percentage as total completions divided by total waivers, which in your cases is only 8.63%. If you did exceed your 15% mark though, this is the formula;
``Please Login or Register  to view this content.``

5. ## Re: Finding unknown value

1st, remove all the merging you have there, it will cause problems with formulas leter on.

2nd, for D9, you cannot add the % together, you have to calc then the same way you did for all the others...
=C9/B9 (these are the references after I removed the extra columns)
then use swhitsel's formula

6. ## Re: Finding unknown value

Thank you everyone!

7. ## Re: Finding unknown value

Happy to help, and thanks for the feedback, guys

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1