+ Reply to Thread
Results 1 to 2 of 2

adding chance to a formula

  1. #1
    Registered User
    Join Date
    03-19-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    16.34
    Posts
    1

    Exclamation adding chance to a formula

    I am using this formula for a population viability analysis: =NORMINV(RAND(),$C$15,$D$15)

    How do I change it or add to it so that there is a 1/100 chance that the value is 0? I want the value to be what my original formula is but there is a 1/100 chance that it could also be 0.

    Please help!!!

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: adding chance to a formula

    Try

    =NORMINV(RANDBETWEEN(0,99)/100,$D$15,$E$15)

    Or ?

    =IFERROR(NORMINV(RANDBETWEEN(0,99)/100,$D$15,$E$15),0)

+ 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] Any chance to process multiple formulas in one formula?
    By annica123 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-02-2019, 11:07 AM
  2. Glad to have a chance
    By keinhong in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-28-2015, 07:10 AM
  3. [SOLVED] Formula to chance decimal to imperial
    By Lensmeister in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2014, 07:37 AM
  4. second chance for Indexation formula problem (truly sorry for first post)
    By peer_1988 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2014, 07:12 AM
  5. no chance to get hh.mm to work
    By blak24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2013, 06:06 AM
  6. Random Chance Formula?
    By MasterCoder84 in forum Excel General
    Replies: 2
    Last Post: 06-30-2010, 11:38 PM
  7. A better chance
    By leo31773 in forum Excel General
    Replies: 4
    Last Post: 09-13-2005, 10:54 AM

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