CODE EXAMPLE FOR TYPESCRIPT

custom function with condition in google sheet

//custom function with Condition
/** 
 * Calculte sales button
 * @customFunction
 */
function salesBonus(salesAmount){
  if(salesAmount>=12000){
    return salesAmount*.25;
  } else if(salesAmount>=10000){
    return salesAmount*.15;
  } else{
    return 0;
  }
}