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