fm3_problems36

# fm3_problems36 - A 1 2 3 4 5 x 1 2 3 B C D Exercise 1 # # #...

This preview shows pages 1–9. Sign up to view the full content.

Exercise 1 x 1 ### #MACRO? 2 ### #MACRO? 3 ### #MACRO? A B C D 1 2 3 4 5

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
VBA Code Function Exercise1(x) Exercise1 = x ^ 2 - 3 End Function E 1 2 3 4 5
Exercise 2 x 1 #MACRO? #MACRO? 2 #MACRO? #MACRO? 1 #MACRO? #MACRO? 2 #MACRO? #MACRO? A B C 1 2 3 4 5 6 7 8 9

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
VBA Code Function Exercise2(x) Exercise2 = (2 * (x ^ 2)) ^ 0.5 + 2 * x End Function Function Exercise2a(x) Exercise2a = Sqr(2 * x ^ 2) + 2 * x End Function D 1 2 3 4 5 6 7 8 9
Exercise 3 100 110 ### #MACRO? 100 200 ### #MACRO? 100 110 ### #MACRO? 100 200 ### #MACRO? P 0 P 1 A B C D E 1 2 3 4 5 6 7 8 9

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
VBA Code Function Exercise3(P0, P1) Exercise3 = Log(P1 / P0) End Function Function Exercise3a(P0, P1) Exercise3a = Application.Ln(P1 / P0) End Function F 1 2 3 4 5 6 7 8 9
Exercise 4 Deposit -1 ### #MACRO? 100 ### #MACRO? 1100 ### 9999.99 ### 10000 ### 10000 ### 100000 ### -1 ### #MACRO? 100 ### #MACRO? 1100 ### 9999.99 ### 10000 ### 10000 ### 100000 ### A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
VBA Code Function Interest(Deposit) If Deposit <= 0 Then Interest = CVErr(xlErrValue) ElseIf Deposit <= 1000 Then Interest = 0.055 ElseIf Deposit <= 10000 Then Interest = 0.063 ElseIf Deposit <= 100000 Then
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/23/2011 for the course FGB 780 taught by Professor Edwardchang during the Spring '09 term at Missouri State University-Springfield.

### Page1 / 16

fm3_problems36 - A 1 2 3 4 5 x 1 2 3 B C D Exercise 1 # # #...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online