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),""))
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),""))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks