IF statements, while intuitive and well understood by most Excel users, can become long and difficult to audit. There are several excellent alternatives to IF that top-notch modelers frequently use. They include using Boolean logic along with a variety of reference functions, including MAX, MIN, AND, OR, VLOOKUP, HLOOKUP, OFFSET.
Cashflow 101 202 Excel Spreadsheets
2ff7e9595c
댓글