This week the Training Team hosted a webinar for students about Excel Logical Functions. This one hour session covered: COUNTIF(S) SUMIF(S) AVERAGEIF(S) IF AND OR IFERROR Nesting Functions Watch a Recording Online If you”re interested in learning about these topics, you can watch a recording online. View the Logical Functions webinar Additional Microsoft Office Webinars We’ve also recorded past [...]
Tag archives for nesting functions
Nesting IF and ISNUMBER to Hide Errors
Sometimes, even when a formula is working correctly, it will return an error, like #N/A or #VALUE!. If you’re sharing your worksheet with someone else, or if you just like a tidy worksheet, you may not like seeing these errors. Fortunately, nesting ISNUMBER into an IF function can eliminate them. The ISNUMBER function checks to see [...]
category: Excel
About
The McCombs Technology Training Team helps UT Austin business students, faculty, and staff with their technology resources, and with Microsoft Office. The trainers are Holly Green and Ben Bond.
Jeff Hauger, a previous team member, contributed several blog posts.
