Round range of cells to equal another cell

[Ace71425]

Hello...I have let's just say 5 cells that are .37, .22, 1.35, .50, .56 which equals the value of another cell in this case 4. Now I need those 5 cells rounded up or down to the nearest .25 but I still need them to equal the other cell 4. How do I put in a round formula that rounds some of the cells conditionally so that the end result equals 4?

 

[shg]

Shouldn't your begin/end times be rounded to the nearest 0:15 before calculating duration?

Those aren't in and out times -- they are raw and rounded times.

 

[Ace71425]

Shg looks like he's on the right path I'll try it in a minute @spiller everything we do has to be broken down based on the type of work we do so like area2, area4, so on and so forth

 

[Ace71425]

shg....unless im doing something wrong with that it worked the first time perfectly but now when I keep playing around with it it seems to be off by .25 like everything....close though!

 

[Ace71425]

0.52 0.5
0.32 0.25
0.74 0.75
0.78 0.75
1.12 1
2.52 2.5
6 5.75
Heres an example

 

[shg]

Row\Col	A​	B​	C​	D​
1​	Project​	Inp​	Out​	​
2​	Project1	0.52​	0.50​	C2: =MROUND(B2 / ($B$9 - SUM(B$1:B1)) * ($B$9 - SUM(C$1:C1)), 0.25)
3​	Project2	0.32​	0.25​
4​	Project3	0.74​	0.75​
5​	Project4	0.78​	0.75​
6​	Project5	1.12​	1.25​
7​	Project6	2.52​	2.50​
8​	Project7	6.00​	6.00​
9​	Total​	12.00​	12.00​

 

[Ace71425]

shg I got it working....I wasnt upping the b1 and c1 as the fields went along....brilliant answer my friend...I greatly appreciate it!

 

[shg]

You're welcome.