examples of formulas on numeric fields and dates

hi, I’m trying to figure out if I can apply formulas to some cells
of the tadabase tables, as in the excel sheets
or create duplicates of lines, with some fields, in excel using macros,
but here I did not understand if it is possible to do this.
thank you