Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

Any way to get around formula size limitations?

Posted by Haywood on November 07, 2001 2:16 PM
I have a rather large formula that I need to expand and cannot because of the formula size governor under the Excel hood. Any suggestions?

Re: Any way to get around formula size limitations?

Posted by iml on November 07, 2001 2:24 PM

If it is an if statement, consider using a lookup function.
If it against 30 arguments, maybe you could use a sumif statement or a manual formula like
=sum(30 arguement)+sum(more arguments)


Why not post the formula you're trying to build? (NT)

Posted by Aladin Akyurek on November 07, 2001 2:28 PM


Re: Any way to get around formula size limitations?

Posted by Haywood on November 07, 2001 2:28 PM
No... it is a payroll calculation for time and a half. looks like this

(C10*($P10*1.5))+(C11*($P11*1.5))+(C12*($P12*1.5))
Where c10 is the hours, p10 is the wage/hour
I need for 100 employees
The formula is for a daily total.



I did in the follow up...

Posted by Haywood on November 07, 2001 2:30 PM


=SUMPRODUCT((C10:C12)*(P10:P12))*1.5

Posted by Anon on November 07, 2001 2:35 PM



Aladin, this could be something!

Posted by IML on November 07, 2001 2:39 PM
I think you could actaully use sumproduct per documentation
=SUMPRODUCT(C1:C100,P1:P100)*1.5


Perfect.. it works. Thanks :)

Posted by Haywood on November 07, 2001 2:57 PM


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.