Two Calculations in one cell?

  • Thread starter Thread starter john.bedford3
  • Start date Start date
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?
 
Hi John

yes, you can, the formula would be:
='Local Teams'!F27 & "(" & 'Local Teams'!F28 & ")"
 
Back
Top