Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to enter a formula

Status
Not open for further replies.
randy700

randy700

Programmer
Joined
Sep 25, 2003
Messages
2,384
Location
US
Using Excel 2007.
I have a few cells that I need to enter formulas.
Most work fine, however, I have some that display the formulat itself, instead of the result.
Can someone tell me how to format the cell so it displays the result of the formula?


Randy
 
Sort by date Sort by votes
Found a solution.
I used the formula tab to insert the function rather than
typing it into the cell.


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question Question
How to get 2 codes to work together.
Replies
6
Views
1K
hermanlaksko
hermanlaksko
caykamanj1966
  • Locked
  • Question Question
Enter information automatically
Replies
5
Views
512
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question Question
Struggling with finding an answer to a simple question
Replies
5
Views
964
BJZeak
BJZeak
PrimoSteve
  • Locked
  • Question Question
Cannot add Image to Command Button?
Replies
9
Views
1K
PrimoSteve
PrimoSteve
MattGreer
  • Locked
  • Question Question
Add Field Description to a Form
Replies
5
Views
673
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top