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.
|