We all know the magic of Excel, hence, using this tool the most. Here are another few assignments with another important formulas of Excel called VOOKUP, IF, IFERROR, AND, OR, IFS and IFNA.