Thread: Negative Exponential

  1. #1
    Its not rocket science vasanth's Avatar
    Join Date
    Jan 2002
    Posts
    1,683

    Negative Exponential

    Can some one tell me how I can generate n number of negative exponential numbers between a gievn range...

    An excel demonstration would really help.... Any one with some time to spare???

    thanx in advance

  2. #2
    & the hat of GPL slaying Thantos's Avatar
    Join Date
    Sep 2001
    Posts
    5,681
    Assuming A2 holds the low value for the range and B2 holds the hi value for the range and assuming that you want 2 to the power of the exponent:
    Code:
    =POWER(2,RAND()*(B2-B1)+B1)
    Only problem is that rand() is called everytime a change is made to the sheet, not sure how to make it call it once per cell

  3. #3
    Its not rocket science vasanth's Avatar
    Join Date
    Jan 2002
    Posts
    1,683
    oopps.. sorry.. i requre to generate set of n numbers which satisfy the negative exponential curve...

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. unsigned negative problem :s
    By nas_am in forum C++ Programming
    Replies: 1
    Last Post: 04-01-2009, 07:35 AM
  2. Can we input negative numbers in the output windiw
    By hitesh1511 in forum C Programming
    Replies: 1
    Last Post: 08-22-2006, 12:07 AM
  3. Negative Numbers
    By Quantrizi in forum C++ Programming
    Replies: 7
    Last Post: 10-12-2003, 12:48 AM
  4. how to handle integer overflow in C
    By kate1234 in forum C Programming
    Replies: 8
    Last Post: 04-23-2003, 12:20 PM
  5. exponential operator
    By mikebrewsj in forum C++ Programming
    Replies: 2
    Last Post: 01-16-2002, 08:05 AM