naxfield.blogg.se - Openoffice calc substring

Converting Numbers into Currency Strings (DOLLAR).Converting Between Numeric Systems (BASE).Join Strings of Text (& or CONCATENATE).Syntax: VDB(Cost Salvage Life Start_Period End_Period Factor No_Switch).Syntax: DDB(Cost Salvage Life Period Factor).Syntax: DB(Cost Salvage Life Period Months).Annual Rate of Interest for Savings (RRI).Syntax: RATE(Time Installment Investment Future Type).Annual Rate of Interest for Loans (RATE).Syntax: PV(lnterest Time Installment Future Type).Syntax: PPMT(lnterest Period Time Loan Future Type).Syntax: PMT(Interest Time Loan Future Type).Syntax: NPER(Interest Installment Loan Future Type).Syntax: IPMT(Interest Period Time Loan Future Type).Syntax: FV(Interest Time Installment Deposit Type).Syntax: DURATION(Interest Investment Future).Syntax: CUMPRINC(Interest Time Capital Start End Type).Cumulative Principal Capital (CUMPRINC).Syntax: CUMIPMT(Interest Time Capital Start End Type).Cumulative Compounded Interest (CUMIPMT).Syntax: FLOOR(Number Significance Mode).

Nearest Multiple Smaller Than or Equal To X (FLOOR).Syntax: CEILING(Number Significance Mode).Nearest Multiple Larger Than or Equal To X (CEILING).

Sum of Squares of Many Arguments (SUMSQ).

Adding New Designs to the Auto-format List.

Referencing Data Stored on Other Computers.

Referencing Data Stored in Other Worksheets.

Referencing Data Stored on Other Sheets.