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?
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)
Posted by Aladin Akyurek on November 07, 2001 2:28 PM
Why not post the formula you're trying to build? (NT)
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.
Posted by Haywood on November 07, 2001 2:30 PM
I did in the follow up...
Posted by Anon on November 07, 2001 2:35 PM
=SUMPRODUCT((C10:C12)*(P10:P12))*1.5
Posted by IML on November 07, 2001 2:39 PM
Aladin, this could be something!
I think you could actaully use sumproduct per documentation
=SUMPRODUCT(C1:C100,P1:P100)*1.5
Posted by Haywood on November 07, 2001 2:57 PM
Perfect.. it works. Thanks :)
