Formula based on total [SOLVED]

[rajeshn_in]

Rows as below


23.700
23.700
23.700
23.700
23.700
26.450
26.450
26.450
_______
197.85

Please provide formula for above rows.

I just try to put maximum rows as 23.7, balance total distribute into same value.

for above rows

First Target is 23.7, balance rows can adjust below 27.7

 

[rajeshn_in]

197.85

I want to divide above total into 8 parts.

23.700
23.700
23.700
23.700
23.700
26.450
26.450
26.450
_______
197.85

I just try to put maximum row 23.7, balance total distribute into same value.main aim is to adjust weight of maximum rows to 23.7. Remaining rows can be adjusted to below 27.7. But the total weight must not change.

Please provide one formula for above rows.

 

[vletm]

A sample file would always help ...
to get an idea of vision.
Try to get an idea from this ...

 

[rajeshn_in]

Please check attachment
In that excel sheet I use 2 formulas G2:G100 and G101
can u provide ONE formula for entire worksheet

 

[vletm]

You used 100 formulas! not two!
Press [Do it]

 

[rajeshn_in]

Small help
Please see attachment,

In G Column, How can I get round-figure for last digit like below

23620
23570
23610
23530
27540
27540
27680
25390

 

[rajeshn_in]

please edit formula and send me formula

 

[NARAYANK991]

Hi ,

Use the MROUND function , as in :

=MROUND(IF(ROWS($F$5:F5)<=8-ROUNDUP(($F$13-8*23600)/4000,0),ROUND(23690-RAND()*200,200),ROUND(27690-RAND()*200,200)),10)

Narayan

 

[rajeshn_in]

Thank you boss, thank you very much, problem solved.
How can I tick this as solved ?