Hello friends,
I need excel formula for range B2:B5
I want the value of cell D1 to be distributed in cells B2:B5 starting from clearing the top most cell
Regards,
Humayun
I need excel formula for range B2:B5
I want the value of cell D1 to be distributed in cells B2:B5 starting from clearing the top most cell
Book3 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Required | Done | Balance | 202,956 | ||
2 | 85,000 | 85,000 | - | |||
3 | 95,000 | 95,000 | - | |||
4 | 45,000 | 22,956 | 22,044 | |||
5 | 60,000 | - | 60,000 | |||
6 | 285,000 | 202,956 | 82,044 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:C5 | C2 | =A2-B2 |
A6:C6 | A6 | =SUM(A2:A5) |
Regards,
Humayun