Decimal combinations to a target sum

sangeethajaikumar

New Member
Joined
Jan 31, 2019
Messages
2
I have a target sum to achieve with some constrains such as - individual numbers have a constant divisor, variable must be of 2 decimals only and sum target for 2 out of 5 data.
The grand total of the row totals must be 62,185.
I tried to use solver, but got stuck.
DivisorHoursRow Total (2 decimals only)
74.03variable of 2 decimalsProduct of Divisor & Hours
74.03variable of 2 decimalsProduct of Divisor & Hours
74.03variable of 2 decimalsProduct of Divisor & Hours
74.03variable of 2 decimalsProduct of Divisor & Hours
74.03variable of 2 decimalsProduct of Divisor & Hours
94.08variable of 2 decimalsProduct of Divisor & Hours

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,099,086
Messages
5,466,545
Members
406,486
Latest member
varmehta

This Week's Hot Topics

Top