To restrict the Accumlate Sum

MamaMonster · #1 03-14-2014, 02:06 AM

Dear Sir,

I am trying to formulate a formula for the below description

Output D3

26 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to restrict Word 2007 to certain formatting only?	XmisterIS	Word	1	10-01-2013 01:51 PM
Restrict styles in a template	chrizzbee	Word	3	03-15-2013 02:23 AM
Restrict Formatting in a Template	Stella	Word	3	07-14-2011 08:21 PM
how can I restrict what characters are allowed in an activex field?	Joe Patrick	Word	2	06-20-2011 05:32 AM
Trick to restrict opening excel/word ??	9morebusy	Excel	0	11-12-2008 04:18 AM