Sending a raw number to a cell from a calculated cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to send the results of a calculated cell to another cell
as a raw number. Example: Cell A1=100, cell A2 contains this formula:
=(A1/.5). A2 will thus contain the results of the formula which is equal to
200. I need that cell, or any cell to contain the answer as a raw number,
not the calculated result. If you click on A2 as it displays 200, it shows
the cell contents as =(A2/.5) not 200 as it need it to.

Can anyone help?
 
Not sure what you're after, but do check HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Does anyone know how to send the results of a calculated cell to another cell
| as a raw number. Example: Cell A1=100, cell A2 contains this formula:
| =(A1/.5). A2 will thus contain the results of the formula which is equal to
| 200. I need that cell, or any cell to contain the answer as a raw number,
| not the calculated result. If you click on A2 as it displays 200, it shows
| the cell contents as =(A2/.5) not 200 as it need it to.
|
| Can anyone help?
 
I was not able to get that to work for me. Maybe this is a better
explaination: Cell A1=100, B1=(A1/.5), I need C1 to = the result from B1 as
just a simple number.

Thank you for your help!
 
In C1:

=B1

What do you see in your worksheet in B1:
200
or
=(A1/.5)
?
If you see =(A1/.5); format as General and re-enter the formula (F2, ENTER)

BTW, what do you mean with a "simple" number? Please give an example of what you expect to see in C1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I was not able to get that to work for me. Maybe this is a better
| explaination: Cell A1=100, B1=(A1/.5), I need C1 to = the result from B1 as
| just a simple number.
|
| Thank you for your help!
|
|
| "Niek Otten" wrote:
|
| > Not sure what you're after, but do check HELP for the INDIRECT() function
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Does anyone know how to send the results of a calculated cell to another cell
| > | as a raw number. Example: Cell A1=100, cell A2 contains this formula:
| > | =(A1/.5). A2 will thus contain the results of the formula which is equal to
| > | 200. I need that cell, or any cell to contain the answer as a raw number,
| > | not the calculated result. If you click on A2 as it displays 200, it shows
| > | the cell contents as =(A2/.5) not 200 as it need it to.
| > |
| > | Can anyone help?
| >
| >
| >
 
Niek,

I have =(A1/.5) in the B1 cell, not 200 when I click on the cell. 200 is
visable in the cell, but the formula remains behind the scenes. I need C1 to
contain the answer from the formula as just the number 200. Just like if you
clicked in C1 and entered 200. No formula behind the cell, just a pure and
simple number. Is there a way to send the results of a cell formula to
another cell? Maybe I can do it that way.

I tried erasing the formula in B1 and entering (F2, ENTER) as suggested, and
all I get in the cell is (F2, ENTER). Nothing more. I know I am quite a
novist at this, but I am trying to import the data to a pricing sheet that
must see the numbers as just numbers, no formulas.

Thanks again
 
Select B1
Format>Cells>Number tab>General>OK

Press F2, then press ENTER

It should be OK now. Is it?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Niek,
|
| I have =(A1/.5) in the B1 cell, not 200 when I click on the cell. 200 is
| visable in the cell, but the formula remains behind the scenes. I need C1 to
| contain the answer from the formula as just the number 200. Just like if you
| clicked in C1 and entered 200. No formula behind the cell, just a pure and
| simple number. Is there a way to send the results of a cell formula to
| another cell? Maybe I can do it that way.
|
| I tried erasing the formula in B1 and entering (F2, ENTER) as suggested, and
| all I get in the cell is (F2, ENTER). Nothing more. I know I am quite a
| novist at this, but I am trying to import the data to a pricing sheet that
| must see the numbers as just numbers, no formulas.
|
| Thanks again
|
| "Niek Otten" wrote:
|
| > In C1:
| >
| > =B1
| >
| > What do you see in your worksheet in B1:
| > 200
| > or
| > =(A1/.5)
| > ?
| > If you see =(A1/.5); format as General and re-enter the formula (F2, ENTER)
| >
| > BTW, what do you mean with a "simple" number? Please give an example of what you expect to see in C1
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > |I was not able to get that to work for me. Maybe this is a better
| > | explaination: Cell A1=100, B1=(A1/.5), I need C1 to = the result from B1 as
| > | just a simple number.
| > |
| > | Thank you for your help!
| > |
| > |
| > | "Niek Otten" wrote:
| > |
| > | > Not sure what you're after, but do check HELP for the INDIRECT() function
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > | > | Does anyone know how to send the results of a calculated cell to another cell
| > | > | as a raw number. Example: Cell A1=100, cell A2 contains this formula:
| > | > | =(A1/.5). A2 will thus contain the results of the formula which is equal to
| > | > | 200. I need that cell, or any cell to contain the answer as a raw number,
| > | > | not the calculated result. If you click on A2 as it displays 200, it shows
| > | > | the cell contents as =(A2/.5) not 200 as it need it to.
| > | > |
| > | > | Can anyone help?
| > | >
| > | >
| > | >
| >
| >
| >
 
Brian

Are you asking for C1 to contain 200 without having a formula in C1 to pull from
B1?

Cannot be done without using VBA

Or in C1 enter =B1 then copy>paste special>value>OK>Esc


Gord Dibben MS Excel MVP

On Sat, 18 Nov 2006 11:41:02 -0800, Brian Denny <Brian
 
Niek,

Sorry for the delay in response, but I took my kids to a bday party and just
returned. No this did not work. Still has the formula in the B1 cell. I
will try Gord's suggestion and see if that works out. And Gord it correct,
this is exactly what I am trying to accomplish.
 
Niek,

I really appreciate your efforts. Many times I try to help someone with the
business I am very good at and don't make the trip, but I always appreciate
someone thanking me for the time I spent with the best of intentions. Your
intentions were pure and thank you so much for your time!
 
Teethless,

Funny screen name. Must be popular with the local guys. Anyway, thanks for
the help. You were right on as well. I appreciate your effort.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations 1
Calculating number of periods 2
Creating a formula relating to several cells 2
Referring to a cell by using another cell for the row number 6
formula for excel sheet. 4
Vlookup and return sheet name also 2
Find certain text in a cell 3
Multiply/Sum cells containing formulas 3

Back
Top