Can I Allow Circular Referencing

TTEMAN · Feb 26th, 2002, 10:06 AM

If i want to have a formula and a money data value eg £1500 in the same cell is this possible. example in cell b1 can i formula =sum(a1-b1)
i know this gives an error but can i get round it please. i am a novice.

THANK YOU Aladin but i want to know is it possible to only use the two cells?

THANK YOU MarkW but my question is can i put formula and data in the same cell? the above was just a simple illustration.
_________________
Many Thanks To All You Helpers

[ This Message was edited by: TTEMAN on 2002-02-26 09:32 ]

[ This Message was edited by: TTEMAN on 2002-02-27 00:43 ]

Aladin Akyurek · Feb 26th, 2002, 10:18 AM

Quote:

On 2002-02-26 09:06, TTEMAN wrote:
If i want to have a formula and a money data value eg £1500 in the same cell is this possible. example in cell b1 can i formula =sum(a1-b1)
i know this gives an error but can i get round it please. i am a novice.

Put in A1: 100
Put in B1: 50
Enter in C1: =A1-B1

Mark W. · Feb 26th, 2002, 11:03 AM

BTW, the SUM() in =SUM(A1-B1) is superfluous! A1-B1 returns a single value, and there's no need to sum a single value.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 10:06 AM	#1
TTEMAN New Member Join Date: Feb 2002 Location: New Horizons UK Posts: 11	If i want to have a formula and a money data value eg £1500 in the same cell is this possible. example in cell b1 can i formula =sum(a1-b1) i know this gives an error but can i get round it please. i am a novice. THANK YOU Aladin but i want to know is it possible to only use the two cells? THANK YOU MarkW but my question is can i put formula and data in the same cell? the above was just a simple illustration. _________________ Many Thanks To All You Helpers [ This Message was edited by: TTEMAN on 2002-02-26 09:32 ] [ This Message was edited by: TTEMAN on 2002-02-27 00:43 ]

Feb 26th, 2002, 11:03 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	BTW, the SUM() in =SUM(A1-B1) is superfluous! A1-B1 returns a single value, and there's no need to sum a single value.