Want to limit amount taken out by a cell to a set amount. Still looking for help with this

put your values in row 1:
A1: 100
B1: 40
C1: 40
D1: 20
E1: 20
in A1: 0
in B2: =IF($A$1>=SUM($B$2:B$2),IF($A$1-SUM($B$2:B$2)>=B$1,B1,$A$1-SUM($B$2:B$2)),0)
and copy across to E2

Hello yudlugar,

What I am getting in the cells B etc is a value of 0.

Thank you,
Richard