Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good afternoon
Does anyone have any ideas on shortening the formula below - its apparently too long (its looking thru a range of cells on different sheets for a specific value). =IF('Assessment 1'!M12*'Assessment 2'!M12*'Assessment 3'!M12*'Assessment 1'!M14*'Assessment 2'!M14*'Assessment 3'!M14*'Assessment 1'!M19*'Assessment 2'!M19*'Assessment 3'!M19*'Assessment 1'!M21*'Assessment 2'!M21*'Assessment 3'!M21*'Assessment 1'!M23*'Assessment 2'!M23*'Assessment 3'!M23*'Assessment 1'!M28*'Assessment 2'!M28*'Assessment 3'!M28*'Assessment 1'!M30*'Assessment 2'!M30*'Assessment 3'!M30*'Assessment 1'!M32*'Assessment 2'!M32*'Assessment 3'!M32*'Assessment 1'!M37*'Assessment 2'!M37*'Assessment 3'!M37*'Assessment 1'!M39*'Assessment 2'!M39*'Assessment 3'!M39*'Assessment 1'!M41*'Assessment 2'!M41*'Assessment 3'!M41*'Assessment 1'!M46*'Assessment 2'!M46*'Assessment 3'!M46*'Assessment 1'!M48*'Assessment 2'!M48*'Assessment 3'!M48*'Assessment 1'!M50*'Assessment 2'!M50*'Assessment 3'!M50*'Assessment 1'!M55*'Assessment 2'!M55*'Assessment 3'!M55*'Assessment 1'!M57*'Assessment 2'!M57*'Assessment 3'!M57*'Assessment 1'!M59*'Assessment 2'!M59*'Assessment 3'!M59*'Assessment 1'!M64*'Assessment 2'!M64*'Assessment 3'!M64*'Assessment 1'!M66*'Assessment 2'!M66*'Assessment 3'!M66*'Assessment 1'!M68*'Assessment 2'!M68*'Assessment 3'!M68=0,"Fail","Pass") Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |