| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
# of Functions per cell
Hi
Is there any way to change the number of functions allowed in each cell? I have a spreadsheet and I need it to handle more functions than 7. 10-15 functions wolud really work well for me. Here is one example of what im working with, I need to have a few more allowed functions for the formula to work correctly. =IF(D11=0,D12,IF(D10=0,SUM(D11:D12),IF(D9=0,SUM(D1 0:D12),IF(D8=0,SUM(D9:D12),IF(D7=0,SUM(D8:D12),IF( D6=0,SUM(D7:D12),IF(D5=0,SUM(D6:D12),SUM(D5:D12))) ))))) Any help would be greatly appreciated Thanks ... --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell format for financial functions | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Can I retain functions from a previous cell when inserting a new r | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
