broncos347
Active Member
- Joined
- Feb 16, 2005
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
Can anyone help me?
I have a formula to calculate risks (see below), however, I have only managed to do one column of a table and have a further 4 columns to go. If I copy any paste the formula so far in to the formula it says the formula is to long.
What I would like to do is complete the formula for the register is to change the cells B6, D8 and D6. B6 and D8 contain text while D6 contains a number.
=IF(D4='Risk Assessment Matrix'!B6,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D6),IF(D4='Risk Assessment Matrix'!B5,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D5),IF(D4='Risk Assessment Matrix'!B4,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D4),IF(D4='Risk Assessment Matrix'!B3,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D3),IF(D4='Risk Assessment Matrix'!B2,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D2),IF(D4='Risk Assessment Matrix'!B1,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D1),
I have a formula to calculate risks (see below), however, I have only managed to do one column of a table and have a further 4 columns to go. If I copy any paste the formula so far in to the formula it says the formula is to long.
What I would like to do is complete the formula for the register is to change the cells B6, D8 and D6. B6 and D8 contain text while D6 contains a number.
=IF(D4='Risk Assessment Matrix'!B6,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D6),IF(D4='Risk Assessment Matrix'!B5,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D5),IF(D4='Risk Assessment Matrix'!B4,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D4),IF(D4='Risk Assessment Matrix'!B3,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D3),IF(D4='Risk Assessment Matrix'!B2,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D2),IF(D4='Risk Assessment Matrix'!B1,IF('Risk Log'!E4='Risk Assessment Matrix'!D8,'Risk Assessment Matrix'!D1),