Chapter 31 - A 1 2 3 4 5 6 B C D E F G H I J K Functions in...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Functions in Action Parameter 1.25 Function1 #MACRO? <-- =Function1(B3) Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the function used in the cell. To edit the code you may press [Alt-F11] and look for a module called Chapter. The function should be in it. A B C D E F G H I J K L 1 2 3 4 5 6
Background image of page 1

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

View Full DocumentRight Arrow Icon
Simple If in Action Parameter 12 #MACRO? <-- =SimpleIf(A4) 3 #MACRO? <-- =SimpleIf(A5) 12 #MACRO? <-- =SimpleIf2(A7) 3 #MACRO? <-- =SimpleIf2(A8) 12 #MACRO? <-- =SimpleIf3(A10) 3 #MACRO? <-- =SimpleIf3(A11) Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the function used in the cell. To edit the code you may press [Alt-F11] and look for a module called Chapter. The function should be in it. A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11
Background image of page 2
BlockIf() in Action Parameter -3 #MACRO? <-- =BlockIf(A4) 0 #MACRO? <-- =BlockIf(A5) 13 #MACRO? <-- =BlockIf(A6) Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the function used in the cell. To edit the code you may press [Alt-F11] and look for a module called Chapter. The function should be in it. A B C D E F G H I J K L M 1 2 3 4 5 6 7
Background image of page 3

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

View Full DocumentRight Arrow Icon
Nested If Function P1 P2 NestedIf(P1, P2) 11 6 #MACRO? <-- =NestedIf(A4,B4) 22 3 #MACRO? -22
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/02/2012 for the course BUSINESS 201 taught by Professor Acknan during the Spring '11 term at MIT.

Page1 / 11

Chapter 31 - A 1 2 3 4 5 6 B C D E F G H I J K Functions in...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online