Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
how do I insert a formula into Excel and number not disappear?
I am using Excel and I am a novice. I am trying to type my formula in the
formula bar but then the number that I want to place in the cell disappears. When I place the number in the cell, the formula disappears. Please help. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
how do I insert a formula into Excel and number not disappear?
"Ruth" wrote:
I am using Excel and I am a novice. I am trying to type my formula in the formula bar but then the number that I want to place in the cell disappears. When I place the number in the cell, the formula disappears. Please help. A cell can only contain either an input value or a formula, at any one time. If you are entering source values in say A1 and B1, just use an adjacent cell to house the formula, eg in C1. C1 could contain the formula, say: =SUM(A1:B1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need assistance setting up formula in excel for number x 15%? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
What is the formula for dividing a number by 4 in excel | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |