+ Reply to Thread
Results 1 to 3 of 3

Show cell as negative value

  1. #1
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    214

    Show cell as negative value

    I have put together a simple future value spreadsheet. See attached.

    Column F represents present value. I see that I need to input the value as negative for Column I to show as a positive value. I want to create a template of this for different clients. Is there a way to enter the value in Col F and have it automatically be a negative number? This will also result in Col I values not showing red. FV.xlsx

    Thank you. Peterino

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,999

    Re: Show cell as negative value

    Couldn't you enter it as a positive number and use this for FV???

    =-FV(H2,G2,,F2)
    Glenn



  3. #3
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    214

    Re: Show cell as negative value

    Well I suppose if I had thought of it first.

    Thanks very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate based on cell value but dont show negative results
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2013, 06:15 AM
  2. [SOLVED] Min/Max of absolute value, show negative if negative
    By vizzkid in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2013, 05:31 PM
  3. Date formula if positive show, if negative don't show.
    By Cyberpawz in forum Excel General
    Replies: 8
    Last Post: 03-14-2012, 07:49 AM
  4. If Negative Show Amount, If Positive Show Zero
    By rdusseau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2008, 11:25 AM
  5. [SOLVED] How to show negative in cell?
    By Brett Romero in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2006, 05:15 AM
  6. Instead of a negative number, I'd like to show zero...
    By Dr. Darrell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-07-2005, 04:25 PM
  7. cell to show ' 0 ' , or nothing at all, if the sum is a negative number
    By rdmdale in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2005, 11:05 AM
  8. Replies: 6
    Last Post: 08-29-2005, 07:05 PM

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