#### broncos347

##### Active Member

- Joined
- Feb 16, 2005

- Messages
- 291

- Office Version
- 365

- Platform
- Windows

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),