. : 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