Results 1 to 4 of 4

Evaluating formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2021
    Location
    Sligo
    MS-Off Ver
    2016
    Posts
    2

    Evaluating formula

    Question. There are some errors in the cells
    • Turn on Trace Precedents for these cells
    • Use the Evaluate Formula feature to find the errors and correct them
    • Remove arrow

    Followed steps above but formula will not calculate. Checked autocalculation is on and show formulas disabled. Format is set to custom too like the other values.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Evaluating the results of a formula within an IF() statement, without duplicating formula?
    By hardofhearing in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2018, 01:08 PM
  2. Evaluating by vlookup and sumproduct formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2013, 08:27 AM
  3. my if formula not evaluating correctly
    By zazzz in forum Excel General
    Replies: 7
    Last Post: 10-29-2012, 02:27 PM
  4. Formula evaluating itself 'on the fly' or a vba macro
    By dziabdak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2012, 09:29 AM
  5. Evaluating a string as a formula
    By LATrojan in forum Excel General
    Replies: 5
    Last Post: 04-27-2009, 01:12 AM
  6. Formula not evaluating immediately
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2006, 02:55 PM
  7. [SOLVED] If formula evaluating 2 cells contents
    By N E Body in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1