|
|
#1
03-14-2014, 02:06 AM
|
|||
|
|||
To restrict the Accumlate Sum
Dear Sir, I am trying to formulate a formula for the below description Output D3  26 Stored E3:E26I 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 
|
|
#3
03-16-2014, 01:49 AM
|
||||
|
||||
|
A workbook might indeed be very useful. OTH you can use the MIN function to not exceed a given value like =MIN(your_formula,290)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
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 |
Windows 8 
Office 2013
Linear Mode
