Skip to content
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Excel Exercises
  • Excel Practice Tests
  • About
  • Contact
  • 0
0 Menu Close
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Excel Exercises
  • Excel Practice Tests
  • 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 Self Assessment Test

  • 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

  • AND/OR

  • ISBLANK

  • VLOOKUP

  • XLOOKUP

  • Pivot Table

  • INDEX MATCH

  • Text to Columns

  • LEFT, MID, RIGHT

  • TEXTBEFORE & TEXTAFTER

  • TEXTSPLIT

  • INDEX

  • MATCH

  • TEXTJOIN

  • CONCAT

  • LEN

  • FIND

  • SEARCH

  • SUBSTITUTE

  • TRIM

  • LOWER, UPPER, PROPER

  • VALUE

  • TEXT

  • 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

  • LET

  • FV

  • VSTACK

  • HSTACK

  • PMT

  • PPMT & IPMT

  • PV

  • Excel Mortgage Calculator

  • How to run a VBA Macro code?

  • Blank Excel Online Worksheet

  • Practice Data Worksheet – Excel Practice Online!

  • Excel Online Cheat Sheet

  • Addition in Excel – Tutorial and Practice

  • Subtraction (minus) in Excel – Tutorial and Practice

  • Multiply Numbers in Excel – Tutorial and Practice

  • Division in Excel – Tutorial and Practice

  • LAMBDA

  • FORMULATEXT Function

  • Concatenate

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

Cart

Terms and Conditions - Privacy Policy