如果onEdit等于特定文本，则调用单元格值的函数value

function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var editedCell = sheet.getActiveCell();
  var editedValue = editedCell.getValue();
  
  if (editedValue == "特定文本") {
    var cellValue = getValueOfCell(editedCell);
    // 执行其他操作或计算
  }
}

function getValueOfCell(cell) {
  var sheet = cell.getSheet();
  var row = cell.getRow();
  var column = cell.getColumn();
  
  var value = sheet.getRange(row, column).getValue();
  return value;
}