View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Living the Dream Living the Dream is offline
external usenet poster
 
Posts: 151
Default Simplifying multiple IF statements?

Hi Ruediger

You don't mention if you want the additional formula to include the same
'System Details' references.

Do these references have predetermined values that add up a score, if so
then use the following:

=IF($B3=("Y"),'System Details'!$E$7)+IF($C3=("Y"),'System
Details'!$E$14)+IF($D3=("Y"),'System
Details'!$E$21)+IF($E3=("Y"),'System
Details'!$E$28)+IF($F3=("Y"),'System
Details'!$E$35)+IF($G3=("Y"),'System Details'!$E$44)+IF($H3=("Y"),
'System Details'!$E$51)+IF($I3=("Y"),'System
Details'!$E$58)+IF($J3=("Y"),'System
Details'!$E$65)+IF($K3=("Y"),'System
Details'!$E$72)+IF($L3=("Y"),'System
Details'!$E$79)+IF($M3=("Y"),'System
Details'!$E$88)+IF($N3=("Y"),'System
Details'!$E$95)+IF($O3=("Y"),'System
Details'!$E$100)+IF($P3=("Y"),'System
Details'!$E$109)+IF($Q3=("Y"),'System
Details'!$E$118)+IF($R3=("Y"),'System Details'!$E$126)

NOTE: the change from Semi-Colon (;) to Comma (,) also the ($) -
absolute reference to each of your original System Details Cells and the
absolute reference for the columns in your main sheet.

You can copy/Paste this down as far as you like.

HTH
Mick.