View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Robert[_2_] Robert[_2_] is offline
external usenet poster
 
Posts: 4
Default Simple calculating ...

Hi
thank you for your mail, but this is not what I need.
I know for "=" and know how to become 5 (from 2+3)
I do not know how to calculate this:

A B
2+3 5

When I enter 2+3 into A cell, cell B need to display 5, not cell A.

Thank you


All (mathematical) calculations IN CELLS of Excel begin with the "="
character (without the Quote marks).

So with cell A1 the current cell enter: =2+3 (and press the enter
key)

A1 should now display the results, which is 5.

In cell B1 enter =A1 (and press enter) B1 Should now display 5
since
A1 = 5.

Does this help?