J
john.bedford3
Is it possible to have 2 separate calculations in one cell?
I have a summary Table on one Sheet which gets its values from two other
sheets.
D E F G H
I
2000/1 2001/2 2002/3 2003/4 2004/5
20 Bonus: Area 15 11 10 6
10(2)
21 Bonus: National 28 29 63 22 39(5)
22 Voucher : Area 22 52 84 54 52(7)
23 Voucher : National 36 7 25 21 17(3)
24 Team event: Area 164 76 167 191 149(10)
25 Team event: National 0 5 19 141 60(4)
For example the formula in row 20 column I is :-
='Local Teams'!F27
The result being 10
What I want to do is include in brackets after this the result of :-
='Local Teams'!F28
Is this possible or will I need to use 2 columns?
I have a summary Table on one Sheet which gets its values from two other
sheets.
D E F G H
I
2000/1 2001/2 2002/3 2003/4 2004/5
20 Bonus: Area 15 11 10 6
10(2)
21 Bonus: National 28 29 63 22 39(5)
22 Voucher : Area 22 52 84 54 52(7)
23 Voucher : National 36 7 25 21 17(3)
24 Team event: Area 164 76 167 191 149(10)
25 Team event: National 0 5 19 141 60(4)
For example the formula in row 20 column I is :-
='Local Teams'!F27
The result being 10
What I want to do is include in brackets after this the result of :-
='Local Teams'!F28
Is this possible or will I need to use 2 columns?