MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 :)