View Single Post
  #1   Report Post  
SUB-ZERO
 
Posts: n/a
Default # 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/ =-