+ Reply to Thread
Results 1 to 6 of 6

one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

  1. #1
    Registered User
    Join Date
    01-03-2019
    Location
    Winchester, CA
    MS-Off Ver
    MAC 2016
    Posts
    3

    one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    Cheers to a New Year!

    As stated above, in one of my formulas using PMT I get the result in red like so: ($123.45) and when I use the PMT in another section I get: -$123.45. Any Ideas what it could be?

    Best Regards

    John Paul

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,627

    Re: one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    Hello johnpaulluna. Welcome to the forum.

    This sounds like a format ... Accounting or Custom ... is applied to those cells .
    Dave

  3. #3
    Registered User
    Join Date
    01-03-2019
    Location
    Winchester, CA
    MS-Off Ver
    MAC 2016
    Posts
    3

    Re: one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    Tried changing to either, now I have black text instead of red.Screen Shot 2019-01-03 at 6.48.36 PM.png

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,627

    Re: one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    OK.

    Which format do you prefer? Try applying that format directly or use Format Painter after you've applied it to one of the ranges.

  5. #5
    Registered User
    Join Date
    01-03-2019
    Location
    Winchester, CA
    MS-Off Ver
    MAC 2016
    Posts
    3

    Re: one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    Good point. I went to 'Number Format' then 'More Number Formats' and found 'Currency' with the option to select red with negative numbers. Thank you for the suggestion!

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,627

    Re: one use of PMT results in ($123.45) and using same formula diff numbers I get -$123.45

    You bet. Glad to help. Thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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. Vlookup Formula which will return results 0 for #N/A and numbers below 50
    By Fredbugatti in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-18-2018, 03:03 PM
  2. formula results are numbers but mostly do not act as numbers
    By Aigi2746 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-17-2018, 11:15 AM
  3. using same formula on diff sheet with diff columns
    By Patcheen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2016, 08:32 AM
  4. Formula to insert serial numbers automatically to an excel sheet with diff. items
    By saranorton in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-16-2015, 09:20 PM
  5. [SOLVED] simple vba formula results in concatenated numbers
    By RJAM99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2014, 05:47 PM
  6. show results in diff cells
    By blackstar in forum Excel General
    Replies: 1
    Last Post: 01-02-2007, 09:53 AM
  7. DATE.DIFF results in French
    By jenhow in forum Excel General
    Replies: 2
    Last Post: 02-15-2005, 06:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1