This is a tabular list of the inmydata predefined functions and examples.

 Function Parameters Calc Example 1 Example 2 Divide numeratordenominator If denominator is not 0 then divide numberator by denominatorExcel : =IF(D3=0,0,C3/D3) Numerator: 10Denominator: 5Calc: 10 / 5 = 2 Numerator: 10Denominator: 0Calc = 0 DecimalSubtract firstvaluesecondvalue Takes second value from first valueExcel: =C6-D6 firstvalue: 10secondvalue: 5Calc: 10 - 5 = 5 Percentage numeratordenominator If denominator is not 0 then divide numberator by denominator and multiple the result by 100Excel: =IF(D8=0,0,(C8/D8) * 100) Numerator: 5Denominator: 10Calc: (5 / 10) * 100 = 50 Numerator: 5Denominator: 0Calc: 0 MarginPercentage salescost if sales is not 0 then take the cost from sales and divide this by salesExcel: =IF(D11=0,0,((C11-D11)/C11) ) Sales: 100Cost: 80calc: (100-80) / 20 = 4 Sales: 110 Cost: 0Calc: = 0 DecimalDifferenceDivided numerator1numerator2denominator if denominator is not 0 take numerator 2 from numerator1 and then divide by the denominator Excel : =IF(E13=0,0,(C13-D13)/E13) numerator 1: 100numerator1: 80denominator: 4calc: (100-80)/4 = 5 numerator 1: 100numerator1: 80 denominator: 0calc : 0 DecimalAddAddSubtract addValue1addValue2addValue2 Add addValue1 to addValue2 then take away  subtractValueExcel: =C16+D16-E16 addValue1: 20addValue2: 50subtractValue: 35Calc: 20+50-35 = 25 DecimalIfNot value1value2 If the firstvalue  is not 0 return first value otherwise return value2Excel: =IF(C18<>0,C18,D18) Value1 : 15Value2: 20Calc = 15 Value1: 0Value3: 20Calc = 20 DiscountPercentage salesdiscountgiven if discountgiven + sales is not 0, divide discountgiven by the value of sales +  discountgiven}Excel: =IF(C21+D21<>0,D21/(C21+D21),0) sales: 80discountgiven: 20Calc = 20 / (80+20) = 0.2 sales: 100discountgiven: -100Calc = 0 ATV salesgrossnoinvoicesnocredits if noinvoices - nocredits is not 0, divide salesgross by the value of noinvoices - nocreditsExcel: =IF(D24-E24<>0,C24/(D24-E24),0) salesgross : 100noinvoices: 30nocredits: 20calc: 100/(30-20) = 10 salesgross : 100noinvoices: 30nocredits: 30calc:0 WeekDay dateTimestartDay Takes a date input and the day number of the start of the week and returns the dayname for the date. The startday number os in the range 0-6 with 0 = sunday CalendarYearFromDate dateTime Returns the year based on the date entered. WeekDayFromString dateTimeStringstartDay Takes a string representation of a date and the day number of the start of the week and returns the dayname for the date. The startday number os in the range 0-6 with 0 = sunday ANGTransactionType value return "sale" or "credit" based on the value entered. Sale if the value is >= 0Excel: =IF(C27>= 0,"Sale","Credit") Value : 150.7Calc : "Sale"Value : 0Calc : "Sale"Value: -1Calc: "Credit" Weeks between two dates date1date2 Takes 2 input dates and determines the number of complete weeks between the 2 values. A value of 0 will result of the input values are invalid. date1: 10/4/2021date2: 26/4/2021 Calc: 2 Days between two dates date1date2 Takes 2 input dates and determines the number of days between the 2 values. A value of 0 will result of the input values are invalid. Hours between two dates date1date2 Takes 2 input dates and determines the number of hours between the 2 values. A value of 0 will result of the input values are invalid. Minutes between two dates date1date2 Takes 2 input dates and determines the number of minutes between the 2 values. A value of 0 will result of the input values are invalid. Seconds between two dates date1date2 Takes 2 input dates and determines the number of seconds between the 2 values. A value of 0 will result of the input values are invalid. Millieseconds between two dates date1date2 Takes 2 input dates and determines the number of milliseconds between the 2 values. A value of 0 will result of the input values are invalid.