D dantb Active Member Joined Mar 20, 2002 Messages 358 Nov 14, 2005 #1 Is it possable to have text included with a formula? I was wondering if I could have the word "Total" inserted somehow in the below formula. Thanks Dan =SUM(E1+G1)
Is it possable to have text included with a formula? I was wondering if I could have the word "Total" inserted somehow in the below formula. Thanks Dan =SUM(E1+G1)
D Derek Well-known Member Joined Feb 16, 2002 Messages 1,592 Nov 14, 2005 #2 Hi there Yes, you can do it like this: ="Total "&SUM(E1+G1) (use "+" when adding numbers but use "&" when adding text) regards Derek
Hi there Yes, you can do it like this: ="Total "&SUM(E1+G1) (use "+" when adding numbers but use "&" when adding text) regards Derek
D dantb Active Member Joined Mar 20, 2002 Messages 358 Nov 14, 2005 #3 Thanks Derek: Works great, learn something new everyday. Thanks again Dan !
PA HS Teacher Well-known Member Joined Jul 17, 2004 Messages 2,838 Nov 14, 2005 #4 Alternatively you could use a custom number format such as: "Total" #.0 This would have the advantage of keeping your sum formatted as a number.
Alternatively you could use a custom number format such as: "Total" #.0 This would have the advantage of keeping your sum formatted as a number.
A Atom New Member Joined Nov 11, 2005 Messages 30 Nov 14, 2005 #5 ADVERTISEMENT PA HS T, That is a great alternative I wouldn't have thought of!
D dantb Active Member Joined Mar 20, 2002 Messages 358 Nov 14, 2005 #6 Thanks PA, nice alturnitive, also works great. Thanks Dan
P PaddyD MrExcel MVP Joined May 1, 2002 Messages 14,234 Nov 14, 2005 #7 ADVERTISEMENT ="Total "&SUM(E1+G1) ...& just to be pedantic, there's no need to do the explicit addition inside the sum(): ="Total "&SUM(E1,G1) or ="Total "&(E1+G1) ...would do.
ADVERTISEMENT ="Total "&SUM(E1+G1) ...& just to be pedantic, there's no need to do the explicit addition inside the sum(): ="Total "&SUM(E1,G1) or ="Total "&(E1+G1) ...would do.
Norie Well-known Member Joined Apr 28, 2004 Messages 76,089 Office Version 365 Platform Windows Nov 14, 2005 #8 And to be even more pedantic you don't need the (). ="Total "& E1+G1
PA HS Teacher Well-known Member Joined Jul 17, 2004 Messages 2,838 Nov 14, 2005 #9 I think this thread is bordering on pettifoggery.