Generate static random numbers within formula

**bebo021999** · 04-10-2015, 01:44 AM

Hi
Do you want to show the CONCATENATE when random number is a specific number, i.e 100

Try:

=IF(AND(B3="",C3="",D3=""),"",IF(RANDBETWEEN(0,50000)=100,CONCATENATE("Student ",B3,"-",C3,"-",100),""))

**SteveTheFish** · 04-10-2015, 02:04 AM

Hi Bebo - If i understand you correctly, I am not looking to generate a specific random number but any random number within the CONCATENATE output that does not update whenever the workbook recalculates.

Sorry if I may not have been clear, the current formula output result is = Student davids-steve-222088
However, when excel recalculates automatically, it will change the Student davids-steve-222088 to something random again. This is what I am trying to hope get asisstance on, to stop this from happening if at all possible.