Kč - Kč ( ) - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč $ - $ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) . . ??? Page 1 ??? (???) 00.00.0000, 00:00:00 Page 1 / 99 COUPPCD Function Result PRAVDA Sheet Result Description 1 PRAVDA Simple COUPPCD formulas with local references and values Function Expected Correct FunctionString Comment Data Description 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 2; 3) 25.01.2011 Settlement date 40497 40497 PRAVDA =COUPPCD(I2;I3;I4;I5) 15.11.2011 Maturity date 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 2; 0) 2 Semiannual coupon (see above) 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 2; 1) 1 Actual/actual basis (see above) 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 2; 2) 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 2; 4) 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 1; 4) 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 4; 4) Err:502 error PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; -4; 4) basis 0 36845 36845 PRAVDA =COUPPCD("2001-01-25"; "2001-11-15"; 4; ) 1 Err:502 error PRAVDA =COUPPCD("2001-11-15";"2001-01-25";4; 1) 2 3 4 4