Skip to content
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Learn Excel for Free
    • Excel Exercises
    • Excel Practice Tests
    • Excel Practice Data
  • Contact
  • About
  • 0
0 Menu Close
  • Excel Practice Online
  • Excel Shortcuts
    • Excel Shortcuts for win
    • Excel Shortcuts for Mac
  • Learn Excel for Free
    • Excel Exercises
    • Excel Practice Tests
    • Excel Practice Data
  • Contact
  • About
  • 0
Excel Practice Online

Practice And Learn Excel Online For Free

IF – Exercise 3

  • Post published:May 16, 2021

In this exercise, you will learn how to use the IF function.

You can view the answers in the Answer tab!

 

 

Can't access the exercise? Below you can find the link to download the Excel file: 

IF_3.xlsx (2252 downloads )

Read more articles

Previous PostData Analyst Practice Test number 2
Next PostMath & Percentages in Excel – 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

  • HLOOKUP

  • INDEX MATCH

  • Pivot Table

  • Text to Columns

  • LEFT, MID, RIGHT

  • TEXTBEFORE & TEXTAFTER

  • TEXTSPLIT

  • INDEX

  • MATCH

  • Concatenate

  • 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

  • CHOOSEROWS

  • CHOOSECOLS

  • TOROW

  • TOCOL

  • 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

Copyright © 2021 - EXCEL PRACTICE ONLINE
×
×

Cart