. : http://uneex.mithril.cs.msu.su/static/GnumericDoc_ru/r3726.html
: Mon Sep 26 12:35:55 2011
: Mon Oct 1 22:44:49 2012
: IBM-866
EFFECT
úº ̺º Gnumeric
PrevNext

EFFECT

Name

EFFECT -- 

Synopsis

EFFECT(r,nper)

Description

ɺ̺ EFFECT ںӶ̺жȺ޶ú ¶ö˺кѶ̺ѶöȺ۶ɺ ʺǺöɺѶɺ кѺ ¶Ⱥ ºɶɶǶ ɶǶͶ̶ɺȺ۶ɶǶ ʺǺöɺѶɶǶ кѺ.

ö˺кѶ̺ѶöȺ۶ɺ ʺǺöɺѶɺ кѺ ںӶ̺жȺ޶úѺк ʶ ԶǺͺȶ:

( 1 + @r / @nper) ^ @nper - 1

¶:

@r = ɶǶͶ̶ɺȺ۶ɺ ʺǺöɺѶɺ кѺ (кѺɶǶȶöɶɺ ¶Ⱥ Ƕ¶ǶǶ ʶú̶Ƕº)

@nper = Ӷ̺жȶ ʶú̶Ƕ¶Ƕ ̺жʶǶȺۺöͶǶ ¶Ⱥ ǶϺٶö¶̶ɶöɶ̺

Examples

See also

NOMINAL.

PrevHomeNext
EDATEUpEOMONTH