Litigaze
Support

Worksheet formulas

Your Plan worksheet includes many built-in formulas to enable fully customizable calculations.

Basic math

Addition and subtraction

= 1 + 2 + 5

= SUM(1,2,5)

= 5 - 2 - 1

= SUM(-1,-2,5)

Multiplication and division

= 1 * 2 * 5

= 9 / 3

= PRODUCT(1,2,5)

Using cell references

= PRODUCT(A1,A2)

= SUM(A1:A5)

Raise to a power (exponentiation)

= POWER(10,2)

Averages

= AVERAGE(A1:A100)

Minimum and maximum values

= MIN(C1:D10)

= MAX(A1, B5, C8)

Financial calculations

Future value

= FV(Rate, Nper, [Pmt], PV, [Type])

Present value

= PV(Rate, Nper, [Pmt], FV, [Type])

Net present value

= NPV(Rate, Value 1, [Value 2], [Value 3]…)

Other formulas

Show today's date

= TODAY()

More formulas...

Many other formulas are supported and can be used in the same way as they would be used in third party spreadsheet apps like Excel or Google Sheets.