+ Reply to Thread
Results 1 to 3 of 3

Amend Formula Syntax Not To Not Show Minus Figures

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Question Amend Formula Syntax Not To Not Show Minus Figures

    Hi,

    I have the following formula i.e.
    Please Login or Register  to view this content.
    =IFERROR((K2-L2),"")
    Please Login or Register  to view this content.
    and was wondering if anyone could assist me in amending it so that if the result is a minus figure it does not display the minus figure but will show the cell as blank (empty)

    Any assistance would be greatly appreciated

    Many thanks in advance

    Regards

    Rob
    Rob

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: Amend Formula Syntax Not To Not Show Minus Figures

    Perhaps something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Re: Amend Formula Syntax Not To Not Show Minus Figures

    BSB

    "EXCELLENT" - Many Thanks

    Regards

    Rob

+ 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. Need to show a minus(-) value in a formula as plus(+) sign..
    By Anuru in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-31-2014, 08:59 AM
  2. [SOLVED] Help to amend sumproduct formula to minus depending on entry in another column
    By KELLIS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 02:15 PM
  3. [SOLVED] Changing minus figures to positive figures
    By sammy011 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-25-2012, 07:10 PM
  4. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  5. formula to show end result after minus from range
    By g4si in forum Excel General
    Replies: 0
    Last Post: 09-22-2010, 11:39 PM
  6. Show minus figures with brackets
    By Louise in forum Excel General
    Replies: 8
    Last Post: 03-19-2010, 02:59 AM
  7. Changing positive figures to minus figures
    By Louise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2005, 06:05 AM

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