Fairly new to Excel and need help with what I hope is a simple formula. Here's what I need.
A + B + C = 100%
If I manually change A, I need B to automatically change to still have the total be 100%. How can I do this?
Fairly new to Excel and need help with what I hope is a simple formula. Here's what I need.
A + B + C = 100%
If I manually change A, I need B to automatically change to still have the total be 100%. How can I do this?
Last edited by FDibbins; 02-07-2014 at 02:14 AM.
assuming D1 is your 100% (in value)
A = A1
C = C1
then
B1=D1-A1-C1
Last edited by humdingaling; 02-07-2014 at 02:20 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
hello monica and welcome to the forum !
in D1 = sum(A1:C1) and drag down!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hi and welcome to the forum
I have changed your thread title to be more in line with our rule 1 (please take a moment to look over them - click the "Forum Rules" in the menu bar at the top of the page)
Now, will it only be A that changes?
B1=100%-A1-C1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Well, first off your title needs changing,
second off, simple arithmetic is what you are looking for ... b=100-a-c...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
@ dred, is there an echo in here?
apparently...possibly several...LOL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks