+ 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
    222

    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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,899

    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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

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

    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. [SOLVED] 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