• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

Displaying formulas rather then Results

EE Pros.,

I think this is a simple problem but I don't know how to fix it.  I have cells that display the formula rather then the formula's results.  How do I change that to reflect "results" not formulas?

B.
0
Bright01
Asked:
Bright01
1 Solution
 
itniflCommented:
I am no excel pro, but I guess when having a equal sign in front of the formula, excel will automatically calculate it.
=A1+B1 displays as 4 when both A1 and B1 are 2.
0
 
Rgonzo1971Commented:
Hi,

or pls try

Goto File /  Advanced  / Options for this worksheet:
Untick: Show formulas in cells instead of their calculated results Option

Regards
0
 
Bright01Author Commented:
Rgonzo1971,

Thank you!  That worked.  I didn't know those options applied only to the worksheet but that's exactly what the problem was.

Thanks again,

B.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now