Results 1 to 17 of 17

Formula Not Displaying Negative Values Correctly

Threaded View

  1. 08-04-2023, 10:08 AM #1
    Frankinstyyn
    Frankinstyyn is offline
    Forum Contributor
    Join Date
    04-09-2014
    Location
    Derby
    MS-Off Ver
    Office 2013 - For my sins
    Posts
    122

    Formula Not Displaying Negative Values Correctly

    Hey all,

    I have written 3 formulas that all work perfectly and show the correct value on the formula builder - screenshot below.

    Screenshot 2023-08-04 at 15.07.06.pngScreenshot 2023-08-04 at 15.07.13.png

    As you can see on the bottom: Result: -1834.94 & -820.4 - that's the correct numbers, but on my spreadsheet the both show ?0.00.

    I've tried changing the number format, but no joy..

    Any help would be really appreciated, thanks.

    Question asked here also: https://www.mrexcel.com/board/thread...ectly.1242561/
    Last edited by Frankinstyyn; 08-04-2023 at 10:32 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Textbox negative values not showing correctly
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-07-2019, 03:16 AM
  2. [SOLVED] VBA Formula not displaying correctly
    By CaptMac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2018, 04:14 AM
  3. Downloading a report - Cell values not displaying correctly
    By KGG in forum Excel General
    Replies: 2
    Last Post: 09-10-2014, 10:55 AM
  4. [SOLVED] Negative or zero values cannot be plotted correctly on log charts
    By NTE in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2012, 11:32 AM
  5. Displaying negative values in a cell but calculating these as 0
    By janschepens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2011, 08:02 AM
  6. Help with importing data - negative values not displaying correctly
    By Toosh in forum Excel General
    Replies: 1
    Last Post: 08-18-2009, 07:35 AM
  7. [SOLVED] displaying negative values
    By cfuller in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-23-2006, 06:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1