| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in cell
Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I
tried it, but it just read 10-5. So I then tried clicking Enter, but it then read Oct 5. How can you do formulas in a cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula in cell
You need an "=" equal sign in front of all calculations and formulas.
-- -John Please rate when your question is answered to help us and others know what is helpful. "albericht" wrote: Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I tried it, but it just read 10-5. So I then tried clicking Enter, but it then read Oct 5. How can you do formulas in a cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula in cell
Replace your 10-5 with the following,
=10-5 The equal sign in front tells Excel that what you've typed is a FORMULA and not just TEXT. Vaya con Dios, Chuck, CABGx3 "albericht" wrote: Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I tried it, but it just read 10-5. So I then tried clicking Enter, but it then read Oct 5. How can you do formulas in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
