+ Reply to Thread
Results 1 to 6 of 6

If cell is negative multiply by -1 formula

Hybrid View

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

    Re: If cell is negative multiply by -1 formula

    I'm not sure why it does that, but it's just the formating of the cell.
    But it is the correct value.

    Just Format the cell with the ABS function as a TIME instead of a Number.

  2. #2
    Forum Contributor
    Join Date
    06-01-2012
    Location
    va
    MS-Off Ver
    2007
    Posts
    163

    Re: If cell is negative multiply by -1 formula

    Duh, stupid me. Sorry haven't completely woken up yet. Thanks.

+ 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] Formula to multiply many cell against each other
    By hammer2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 08:49 AM
  2. If and Then Formula/Code to multiply with a Designated Cell
    By aaron.mendes in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-09-2013, 03:08 PM
  3. [SOLVED] Need help with a Multiply Dependent One Cell Formula
    By derekblain in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2006, 05:35 PM
  4. formula cell value multiply by percentage
    By formula using percentage question in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2006, 09:25 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