This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
In my Home Student Excel for Mac 2019 I can't find the Randomize functions like RANDBETWEEN and RAND, even though I checked the Analysis Tool Pack and Solver add-in.
Is that correct?
So if I upgrade to Excel for Mac 2021, do I get these functions RAND and RANDBETWEEN?
Thanks for helping.
Geert
***moved from nl-nl***
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Both of those functions are regular functions... Neither is contained in the Analysis ToolPak or has any relation to Solver.
Hello, GeertvSt.
Welcome to Microsoft Community!
We noticed that you don't seem to find the RAND and RANDBETWEEN functions in your Excel for Mac 2019, but according to the official instructions, we are able to find these two functions in the instructions are supported by Excel for Mac 2019:
RAND function - Microsoft Support
RANDBETWEEN function - Microsoft Support
You can try typing directly into the cell:
RANDBETWEEN(1,100)
to see if it really doesn't respond. If it doesn't, we suggest you reinstall excel.
In addition, regarding your mention of upgrading Excel for Mac 2019 to Excel for Mac 2021, we would like to remind you that these are two different permanent versions, and if you choose to switch, you will need to purchase it, so please consider your current usage plan carefully before making a decision.
Best Regards,
Airy-MSFT | Microsoft Community Support Specialist