Home

Formula excel

%3CLINGO-SUB%20id%3D%22lingo-sub-562764%22%20slang%3D%22en-US%22%3EFormula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562764%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20am%20trying%20to%20make%20a%20random%20sample%20and%20the%20formula%20'%3DRAND()'%20does%20not%20work.%20I%20have%20followed%20all%20advice%20online%20available%2C%20but%20still%20nothing%20has%20changed.%20I%20get%20the%20notification%20that%20the%20formula%20is%20not%20valid.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20can%20help%20me%20further%20solve%20this%20issue%2C%20because%20it%20is%20quite%20time-consuming.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESoraya%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-562764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562790%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562790%22%20slang%3D%22en-US%22%3Ewhich%20version%20of%20Ms%20Excel%20are%20you%20using%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562823%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562823%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20Thank%20you%20for%20the%20quick%20response.%20Excel%2016.16.9%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562838%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341234%22%20target%3D%22_blank%22%3E%40Sjansen1993_%3C%2FA%3E%26nbsp%3Bi%20cant%20see%20any%20reason%20for%20that%20error.%20try%20in%20other%20system%2C%20and%20reply.%20waiting%20for%20your%20reply.%20%3B)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562932%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341234%22%20target%3D%22_blank%22%3E%40Sjansen1993_%3C%2FA%3E%26nbsp%3B%2C%20are%20on%20English%20version%20and%20what%20exactly%20error%20do%20you%20have%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-563284%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-563284%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20just%20curious.%20Ensure%20that%20no%20other%20characters%20are%20included%20in%20your%20formula%2C%20except%20this%3A%3CBR%20%2F%3E%3DRAND()%3C%2FLINGO-BODY%3E
Sjansen1993_
New Contributor

Hi! I am trying to make a random sample and the formula '=RAND()' does not work. I have followed all advice online available, but still nothing has changed. I get the notification that the formula is not valid. 

I hope you can help me further solve this issue, because it is quite time-consuming.

 

Best,

 

Soraya

 

 

5 Replies
which version of Ms Excel are you using?

Hi! Thank you for the quick response. Excel 16.16.9 

@Sjansen1993_ i cant see any reason for that error. try in other system, and reply. waiting for your reply. ;)

@Sjansen1993_ , are on English version and what exactly error do you have?

I’m just curious. Ensure that no other characters are included in your formula, except this:
=RAND()