+ Reply to Thread
Results 1 to 6 of 6

formula for plus and minus figures

  1. #1
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    315

    formula for plus and minus figures

    Is there any formula or way by which I can put numbers in plus and minus both in a certain range (it does not matter whatever the length of numbers), as an example i'm attaching a sheet but for this I have to put minus sign before the formula and have to choose different cells at random
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: formula for plus and minus figures

    So do you want random numbers between -500 & -1000 OR +500 & +1000?

  3. #3
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    315

    Re: formula for plus and minus figures

    yes but both the numbers in the range it does not matter the length and range for numbers, it may two cell or thousand cells

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: formula for plus and minus figures

    What about this;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,502

    Re: formula for plus and minus figures

    or just:
    Please Login or Register  to view this content.
    Ben Van Johnson

  6. #6
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    315

    Re: formula for plus and minus figures

    Thank you very much for your solution

+ 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. Replies: 2
    Last Post: 11-28-2016, 09:27 PM
  2. [SOLVED] Amend Formula Syntax Not To Not Show Minus Figures
    By robertguy in forum Excel General
    Replies: 2
    Last Post: 04-27-2016, 07:38 AM
  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. exclude minus figures?
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2008, 05:25 PM
  5. Changing positive figures to minus figures
    By Louise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2005, 06:05 AM
  6. [SOLVED] calculate minus figures
    By Nigel in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 12:06 PM
  7. Calculate minus figures only
    By Nigel in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 08:45 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