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 |