RANDBETWEEN funtion is missing from my new Excel.

M

Mr_Function

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?
 
B

bpeltzer

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).
 
Top