如何让函数变得简单

Question

也许删除一些逻辑运算符，制作“检查功能”？

还是将一些逻辑连接在一起？

// 功能

function getTicketPrice(childNumber,adultNumber){

  if (childNumber > 2 && adultNumber > 2) {

    return "-";

  }

    if (childNumber == 2 && adultNumber == 3) {

    return "-";

  }

    if (childNumber == 3 && adultNumber == 2) {

    return "-";

  }  

  var sheet = SpreadsheetApp.openByUrl(url).getSheetByName("Ticket");  

  var row = getTicketPriceChild(childNumber, sheet);

  var col = getTicketPriceAdult(adultNumber, sheet);

    if (row >-1 && col === undefined) {

    return "-";

  }

    if (row === undefined && col >-1) {

    return "-";

  }    

  var value = sheet.getRange(row, col).getValue();

    if(value > 1){

    return value;

  } else {

    return '-';

  }

}

Answer 1

像这样的东西：function getTicketPrice(childNumber, adultNumber) {  if ((childNumber > 2 && adultNumber > 2) || (childNumber == 2 && adultNumber == 3) || (childNumber == 3 && adultNumber == 2))    return "-";  const sheet = SpreadsheetApp.openByUrl(url).getSheetByName('Ticket');  const row = getTicketPriceChild(childNumber, sheet);  const col = getTicketPriceAdult(adultNumber, sheet);  if ((row > -1 && col === undefined) || (row === undefined && col > -1))    return "-";  const value = sheet.getRange(row, col).getValue();  return value > 1 ? value : "-"}