Two Operations - One Cell

sjp6375 · Mar 28th, 2002, 07:32 PM

Hello-

I have built a table using the B$1*$A2 format (cf. General Excel Techniques dtd 12/27/00). However, I would like this table to perform two separate operations, and give the result (in one cell) in the form of an ordered pair.

Example: B1 =10; A2=10

In B2, I type a formula A2*B1 AND A2+B1 (in order to copy and paste this formula throughout the table (as discussed above).

The result displayed in B2 is of the form (100,20) - the individual results for two separate operations.

Thank you for your time.

Dave Patton · Mar 28th, 2002, 07:42 PM

What is the goal of this exercise?

A ss has millions of cells; it might be appropriate to keep results in cells that
can be utilized for calculations.

see
="("&A2*B1&","&A2+B1&")"

Gives (100,20) but it is Text.

[ This Message was edited by: Dave Patton on 2002-03-28 18:43 ]

Dave Hawley · Mar 28th, 2002, 07:57 PM

Hi sjp6375

Must fully agree with Dave (what a great name) there are 655536rows*256Columns of cells. Good spreadsheet designing often means placing data into their won cells. It is very easy to join cells into one cell, but the reverse is often harder.

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

Mar 28th, 2002, 07:32 PM	#1
sjp6375 New Member Join Date: Mar 2002 Posts: 2	Hello- I have built a table using the B$1$A2 format (cf. General Excel Techniques dtd 12/27/00). However, I would like this table to perform two separate operations, and give the result (in one cell) in the form of an ordered pair. Example: B1 =10; A2=10 In B2, I type a formula A2B1 AND A2+B1 (in order to copy and paste this formula throughout the table (as discussed above). The result displayed in B2 is of the form (100,20) - the individual results for two separate operations. Thank you for your time.

Mar 28th, 2002, 07:42 PM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	What is the goal of this exercise? A ss has millions of cells; it might be appropriate to keep results in cells that can be utilized for calculations. see ="("&A2*B1&","&A2+B1&")" Gives (100,20) but it is Text. [ This Message was edited by: Dave Patton on 2002-03-28 18:43 ]

Mar 28th, 2002, 07:57 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi sjp6375 Must fully agree with Dave (what a great name) there are 655536rows*256Columns of cells. Good spreadsheet designing often means placing data into their won cells. It is very easy to join cells into one cell, but the reverse is often harder.