Microsoft Office Forums Filling in cells based on 2 other cells data
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-09-2018, 05:49 PM
 Dawindle Windows 10 Office 2016 Novice Join Date: Nov 2018 Posts: 2
Filling in cells based on 2 other cells data

I need to figure out how to enter data fro column b and then subtract that from column a and enter the new value, then keep that going to formulate each days target for the whole month

So if cell a1 is 105 and b1 has a goal of 33 a day then c1 is 33.

Then c2 and c3 would need to also be 33
Then c4 would be the 6 remaining plus the goal from b2
So a2 would be 19 and b2 would be 27
And so forth
#2
11-09-2018, 09:07 PM
 Marcia Windows 7 32bit Office 2007 Competent Performer Join Date: May 2018 Posts: 159

How did you arrive at 19 as the value for A2? is A2 dependant from the values of the other cells areas? You said c4 is equal to 6 plus B2 or 27 so c4 value is 33, right?
#3
11-10-2018, 04:31 AM
 Dawindle Windows 10 Office 2016 Novice Join Date: Nov 2018 Posts: 2

Sorry column a would be the order amounts which i would put in at the begining of the month. Column b will be a lookup for the daily output possible from the order amount in column a. That is all done and working. Column c is my issue. It needs ro be the target set for each day
#4
11-10-2018, 07:14 AM
 Marcia Windows 7 32bit Office 2007 Competent Performer Join Date: May 2018 Posts: 159

Let's wait for the experts to provide the solution. It's not the regular IF and SUM operations because my understanding is the daily goal (column c) remains static until the first order had been filled, any remaining balance (first order less accumulated goal in Col C) will then be added to the next goal in column B.
#5
11-10-2018, 07:40 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Moderator Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,335

@dawindle
Hi and welcome
please post a sample sheet with some data and expected results
( click Go advanced - Manage attachments)
Thank you
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post otuatail Excel 3 08-17-2017 11:31 PM RayK Excel 1 01-12-2017 04:14 PM deejay Excel 6 12-20-2016 12:00 PM KerryOn Excel 2 08-10-2015 08:41 PM VinceO Excel 1 05-09-2011 06:38 AM

All times are GMT -7. The time now is 10:35 PM.

 -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top