{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 31

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

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

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

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

View Full Document
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
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

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

View Full Document
Nested If Function P1 P2 NestedIf(P1, P2) 11 6 #MACRO? <-- =NestedIf(A4,B4) 22 3 #MACRO? -22 6 #MACRO? -57.3 4 #MACRO?
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}