Dear Sir,

I am trying to formulate a formula for the below description

Output D326 Stored E3:E26
I have the following formula to compute the data for stored
"IF(D31>10,IF(D31>20,IF(D31>30,IF(D31>40,IF(D31>50 ,50,40),30),20),0))"

However, I want to restrict the accumulated stored to the extend it will not exceed 290. Meaning if Accumulated Stored at E16 is 290 already and i want restrict E17:E26 = 0 even if it meet the 'IF' What else should i add?

Thanks in advance