Microsoft Office Tutorials and References
In Depth Information
Appendix: Using the IF Function in Mac Excel 2011
FIGURE 8.14 Nested IF Results
APPENDIX: USING THE IF FUNCTION IN MAC EXCEL 2011
The IF Function Menu only looks different from the Excel 2007 or 2010 versions.
You can use the Excel Functions menu, f x , to achieve the same result. Select the
functions menu (click f x ). Select Logical and choose IF. See Figure 8.15. All the rest is
the same as described above.
FIGURE 8.15 Using the If Function Menu with Mac Excel 2011