Results 1 to 10 of 10

Substitute & get randbetween from cell reference

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-25-2021
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    2,171

    Substitute & get randbetween from cell reference

    Hello guys,
    I have the randbetween value in a cell and the multiple value in the other cell. I want to get values with the help of randbetween formula in cells H2 to H15. I want the formula to select the randbetween amount from the cell B2 and the multiples value from the cell C2. How do I combine the above 2 formulas into one and get the result?
    If , in the B column, I write the value as 6-10, it is not accepting in the general format. Since, multiples is used in most of the cases, I would like to know how to enter 6-10 or directly 6,10 which also is not accepted by excel in the required format. Something like this '=RANDBETWEEN(SUBSTITUTE(B2,"-",")*C2 but it ain't working.
    Last edited by RAJESH SHAH; 09-25-2022 at 05:08 PM. Reason: #Solved by HansDouwe

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Substitute reference in cell formula with another reference.
    By harpbelle in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-17-2021, 01:03 AM
  2. [SOLVED] got a RandBetween that uses a cell to reference but I need the value to be put in it
    By Michael Island in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2020, 06:59 AM
  3. [SOLVED] How to replace or substitute function formulas but left the cell reference intact?
    By Franky alta in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-02-2016, 12:48 AM
  4. Replies: 10
    Last Post: 07-03-2015, 04:29 PM
  5. [SOLVED] Can i substitute using a cell reference?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-25-2013, 03:17 PM
  6. How to substitute dates using cell reference in SQL query using VBA
    By labman39 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2012, 01:07 AM
  7. Replies: 11
    Last Post: 02-22-2006, 09:20 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