. : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r3726.html
: Mon Sep 26 12:35:55 2011
: Tue Oct 2 07:23:24 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