EFFECT Function (Gnumeric)

This page concerns Gnumeric (GNOME’s spreadsheet application), not the identically named feature in another spreadsheet. The official Gnumeric Finance reference documents the signature and behaviour, and the public function catalogue lists the function’s implementation as Complete with Basic upstream testing (both checked 2026-10-13). The Gnumeric 1.12.62 release announcement confirms the target release exists, but this manuscript does not establish that every supported operating-system package ships identical binaries or that our examples ran in that version. Consult your distribution’s Gnumeric package and function list. These are finance functions, not optional add-ins asserted to be available on every platform.

Formula syntax below uses the English function name, decimal point and comma-separated arguments shown by the English Gnumeric reference. Some installations use a localized decimal separator and/or argument delimiter; check the on-screen Function Selector and adapt syntax rather than pasting commas blindly. Put percentage values in cells as numbers formatted as percentages (for example, 6% = 0.06); do not type the number 6 when you mean six percent.

EFFECT converts an annual nominal interest rate, quoted with a stated number of compounding periods in the year, into an effective annual interest rate. The latter reflects interest added to principal during that same year. It is useful when comparing two savings accounts quoting the same nominal rate but different compounding frequency. It does not calculate the total account balance, a loan’s monthly payment or an investment return that includes variable rates or fees. The Gnumeric manual explicitly supplies the mathematical identity below. Official Gnumeric Finance reference, EFFECT, checked 2026-10-13.

=EFFECT(rate,nper)

The documented formula is (1 + rate/nper)^nper - 1. The result is a rate, not money: format it as Percentage for display. A nominal 6% compounded quarterly means rate=0.06, nper=4, and a periodic interest rate of 1.5%. Official manual.

Enter the following values (use the exact cell positions):

Independent calculation: (1+0.06/4)^4−1 = 0.061363550625. You may see fewer digits when cell formatting limits display precision. The equality test verifies arithmetic; it is not a record of a Gnumeric execution.

Place 1, 4, 12 in cells D2:D4. In E2, enter =EFFECT($B$2,D2) and fill down to E4.

With the same positive nominal rate, more frequent compounding slightly increases the effective annual rate in this conventional model. A finance advertisement might call the result an annual percentage yield; advertising conventions and fees may differ, so this calculation alone does not certify a regulated quoted APY or APR.

Use =NOMINAL(B4,B3) to turn the EFFECT output back into its nominal quote: the independent expected rate is 6.0000000000%. If you want the value of $10,000 invested for five years at the unchanging nominal 6% compounded quarterly, the independent formula is =10000*(1+$B$2/$B$3)^(5*$B$3), giving approximately $13,468.55. That amount assumes no contributions, withdrawals, taxes or fees. The comparable effective-annual expression =10000*(1+B4)^5 is mathematically equal apart from floating-point rounding. These examples are finance-math derivations, not claims of installed-function execution. Gnumeric manual, EFFECT and NOMINAL.

• Wrong rate period: =EFFECT(6%/12,12) interprets 0.5% as the annual nominal rate and is wrong for a 6% annual quote. Supply 6% in rate.

• Different fee structures: EFFECT accounts for compounding only, not banking service charges, tiered promotional yields, variable day counts or irregular deposits. Calculate those separately before comparing offers.

• Output looks like 0.06136: it is an unformatted rate; apply Percentage to show 6.136…%. Rounding the displayed rate early can obscure comparisons.

Source-verified input bounds (1.12.62): The implementation floors numeric nper to an integer and returns a NUM-kind error when that count is below 1 or when rate is zero or negative. These are source branches, not observed error displays. Use positive rates and positive whole compounding counts; arbitrary text coercion remains untested.

• NOMINAL — recover the nominal yearly quote
• FV — future value with scheduled payments
• PV — present value
• RATE — infer a periodic rate from cash flows

Official sources were checked on 2026-10-13:

1. Gnumeric manual — Finance function reference: exact Gnumeric signature, argument names, purpose and documented defaults; relevant function heading EFFECT. This is documentation evidence, not an execution trace.
2. Gnumeric official function catalogue: lists effect as Complete / Basic; catalogue classification is not a guarantee that this manuscript’s test values passed a native session.
3. GNOME Gnumeric 1.12.62 release announcement: version context. The web reference is updated separately from specific installed builds, and the reviewed implementation is scoped to the checksum-verified official 1.12.62 source archive. No native application execution was performed.

Validation scope: Official documentation and checksum-verified Gnumeric 1.12.62 source were reviewed; example arithmetic was independently recalculated. Native Gnumeric execution, screenshots, locale/platform regression tests and workbook round-trips were not performed.