ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   RANDBETWEEN funtion is missing from my new Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/90448-randbetween-funtion-missing-my-new-excel.html)

Mr_Function

RANDBETWEEN funtion is missing from my new Excel.
 
On this newly installed update of Office Student - Teacher version the
RANDBETWEEN, LCM, and GCD functions are not available even though directions
for them are in the help menus. What should I do to correct this?

bpeltzer

RANDBETWEEN funtion is missing from my new Excel.
 
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. (From the menu bar, Tools Add-ins and
select Analysis Tool-Pak, assuming this is available in the Student-Teacher
version).

"Mr_Function" wrote:

On this newly installed update of Office Student - Teacher version the
RANDBETWEEN, LCM, and GCD functions are not available even though directions
for them are in the help menus. What should I do to correct this?



All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com