View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DEAN0 219 DEAN0 219 is offline
external usenet poster
 
Posts: 2
Default Formula too long

I'm trying to use a Logical Formula.
IF('Sheet 1'!B170,'Sheet 1'!B2*'Sheet 2!B3+'Sheet 1'!B3*Sheet 3!B3...ect.,
0).
But in the TRUE logical it will only let me put so many (cell 1 * cell 2)
equations. Is there a way to overide this or is there another way to do this.

--
Best Regards,
Deano