#1
|
|||
|
|||
Display Formula in Once Cell, Result in Another
I was watching a video on Excel formulas and the author was showing a formula in one cell, and the result of the formula in another cell. Both cells had the same formula bar text. I could not figure out how she did this. Can someone please explain?
|
#2
|
|||
|
|||
One cell was formatted as text
|
#3
|
|||
|
|||
I tried formatting one cell as text. It still displayed the result and not the formula.
|
#4
|
|||
|
|||
Okay, if I typed a formula in a cell and then changed the format to text afterwards, the result is displayed. However, if I change the format to text before I typed the formula in, the formula is displayed. I would think it should work the same either way, but at least I know a way to do this now. Thanks.
|
#5
|
|||
|
|||
When you change the format of cell/range, the change will be actual only after you edit the cell(s). Until then the old format is applied really.
So when you have e.g. a column with numbers or dates formatted as text, and you format the column to General or Date, after formatting the column you have to edit all entries in column. The fast way is enter 0 or 1 into some free cell elsewhere, copy the cell, and then PasteSpecial>Add or PasteSpecial>Multiply the formatted column. When you want to format numeric column to text, a foolproof way is after formatting to enter the formula Code:
= "" & CellReference With one or couple of cells only, simply double-click on cell, or activate it and press F2, and then press Enter. |
#6
|
|||
|
|||
Maybe the attached can be of some use.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula result not displaying in cell (but f9 works) | nath1235 | Excel | 4 | 10-06-2017 12:42 PM |
Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
Show result of formula as a value in another cell | Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
If formula result is negative then display text | oxicottin | Excel | 3 | 12-03-2012 02:12 AM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |