1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| function getRandomNumber(min, max) {
return Math.floor(Math.random() * (max - min+1) + min);
}
function test5() {
for (var i=2;i<22;i++) {
var spreadsheet = SpreadsheetApp.getActive();
var cell = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Matrice").getRange(i,9);
var min = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Matrice").getRange(i,5).getValue();
var max = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Matrice").getRange(i,6).getValue();
var randomNumber = getRandomNumber(min, max);
cell.setValue(randomNumber);
}
} |
Partager