+ Reply to Thread
Results 1 to 4 of 4

Changing value to a negative. How?

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    240

    Question Changing value to a negative. How?

    Cell N15 =K15+(L15/60+M15/3600)

    I will always get a numeric value. How can I get my value to have a negative sign... as in, the value of what I get from following my N15 formula, but just make it negative?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Changing value to a negative. How?

    Perhaps

    =-(K15+(L15/60+M15/3600))

  3. #3
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    240

    Re: Changing value to a negative. How?

    Wow!!! now i feel stupid... lol
    Thanks

  4. #4
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    240

    Re: Changing value to a negative. How?

    Now, on to something a little harder.

    http://www.excelforum.com/excel-gene...-clicking.html

+ 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. Changing negative value to 0
    By sandbach in forum Excel General
    Replies: 4
    Last Post: 11-05-2010, 01:58 PM
  2. Changing the Negative Sign
    By tedd13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2006, 12:10 PM
  3. Changing negative numbers to zero
    By Chet T in forum Excel General
    Replies: 5
    Last Post: 10-07-2005, 10:05 AM
  4. [SOLVED] Changing Positive to Negative
    By Matthew Hackett via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Changing Positive to Negative
    By in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Changing Positive to Negative
    By Matthew Hackett via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. Changing Positive to Negative
    By Matthew Hackett via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. Changing Positive to Negative
    By Matthew Hackett via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2005, 07:05 AM

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