Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel |