Thread: [Solved] Formula Help
View Single Post
 
Old 07-09-2016, 05:56 AM
yljayhawk yljayhawk is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2016
Posts: 3
yljayhawk is on a distinguished road
Default

B3 = $150 and C3 =$450
Then
C4 = $45; D4 = $180; E4 = $180; F4 = $180; G4 = $180; H4 = $180; I4 =are three $150 equaling $450, there will be three $45, totaling $135, in D4-Q4. And there is a total of four $45, totaling $180, in D4-N4.

And want this to continue to build as $150 amounts are inputed into cells in row three, row four is populated with twelve cells of $45. And these $45 will continue to add up too. $180; J4 = $180; K4 = $180; L4 = $180; M4 = $180; N4 = $180; O4 = $135
Because each $150 entered in row 3 will project out twelve cells of $45 in row 4.
So B3 has one $150 then there will be one $45 in C4-N4. Because there
Reply With Quote