| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
the answer dont display just the formula i input help
when i type the formula in the cell j5
=k3-100 it does not display changes when i try to input a value in k3 the formula is still displayed at j5 and does not show the answer there. help pls |
|
#2
|
|||
|
|||
|
Go to Tools Options
View tab. In the windows option, unchek the box Formulas Mangesh "Dimetre" wrote in message ... when i type the formula in the cell j5 =k3-100 it does not display changes when i try to input a value in k3 the formula is still displayed at j5 and does not show the answer there. help pls |
|
#3
|
|||
|
|||
|
Your cell was probably formatted as text before you entered the formula.
Format as General or Number and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Dimetre" wrote in message ... when i type the formula in the cell j5 =k3-100 it does not display changes when i try to input a value in k3 the formula is still displayed at j5 and does not show the answer there. help pls |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrong answer after using the payment formula in excel | New Users to Excel | |||
| Modifying a Formula To display only Unique Values | Excel Worksheet Functions | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
| How to solve a formula so that it returns actual answer if negati. | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
Hybrid Mode
