Skip to content
  • Excel Practice Online
  • Excel Exercises
  • Excel Shortcuts
  • About
  • Contact
  • 0
0 Menu Close
  • Excel Practice Online
  • Excel Exercises
  • Excel Shortcuts
  • About
  • Contact
  • 0
Excel Practice Online

Practice And Learn Excel Online For Free

IF – Exercise 4

  • Post published:May 16, 2021

In this exercise, you will learn how to use the IF function, as well as combining it with mathematical operations.

You can view the answers in the Answer tab! 🙂

 

Read more articles

Previous PostIF – Exercise 3
Next PostNested IF – Exercise Number 1

Functions & Tools

  • Excel Basics

  • SUM

  • MAX

  • MIN

  • COUNTA

  • COUNT

  • AVERAGE

  • Filter Tool

  • Sort Data

  • Flash Fill

  • Remove Duplicates

  • IF

  • Nested IF

  • Conditional Formatting

  • SUMIF

  • COUNTIF

  • AVERAGEIF

  • SUMIFS

  • COUNTIFS

  • MAXIFS

  • MINIFS

  • VLOOKUP

  • XLOOKUP

  • Pivot Table

  • INDEX MATCH

  • Text to Columns

  • LEFT, MID, RIGHT

  • AND/OR

  • INDEX

  • MATCH

  • TEXTJOIN

  • CONCAT

  • LEN

  • FIND

  • SEARCH

  • TRIM

  • LOWER, UPPER, PROPER

  • DAY, MONTH, YEAR

  • DATE

  • WEEKDAY

  • EOMONTH

  • IFERROR

  • SUMPRODUCT

  • Excel Wildcards

  • Advanced Filter

  • Power Query – Combine data from multiple workbooks

  • Power Query – Column from Examples

  • Unpivot columns using Power Query

  • UNIQUE

  • SORT Function

  • SORTBY

  • FILTER Function

  • RANDARRAY

  • SEQUENCE

  • PMT

  • PPMT & IPMT

  • How to run a VBA Macro code?

  • Blank Excel Online Worksheet

  • Practice Data Worksheet – Excel Practice Online!

  • Terms and Conditions
  • Privacy Policy
Copyright © 2021 - EXCEL PRACTICE ONLINE
×
×

Cart

Terms and Conditions - Privacy Policy