ARTICLES LES PLUS VUS

  1. Displaying Negative Numbers in Parentheses – Excel (270,354)
  2. The 10 most useful Excel Functions in 2023 (198,717)
  3. How to make automatic calendar in Excel (169,318)
  4. Dash for a zero in Excel (138,802)
  5. Convert YYYYMMDD to DD/MM/YYYY with Excel (123,853)
  6. Date Format in Excel (119,565)
  7. Excel Split Date and Time (97,642)
  8. How to calculate VAT in Excel? (93,334)
  9. Function XLOOKUP in Excel (87,986)
  10. Exchange rate in Excel (86,786)
  11. UNIQUE Function – Remove duplicates with formulas (73,020)
  12. Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde (68,486)
  13. Comma or Semicolon in an Excel formula (64,030)
  14. Add Emojis to your Excel charts, formulas (63,933)
  15. How to Compare 2 Columns in Excel (58,512)
  16. Change the default Date format in Excel (57,420)
  17. SUMIFS Function in Excel (50,670)
  18. COUNTIFS – Count rows automatically in Excel (48,156)
  19. Dynamic SUM in Excel (47,839)
  20. Add filter option for all your pivot table columns (47,592)
  21. How to display hours over 24 in Excel? (41,526)
  22. Anonymise your data (38,516)
  23. First day – Last day in Excel (35,216)
  24. Round to the Nearest Tenth, Hundredth with Excel (33,945)
  25. Find Weekend or Weekday in Excel (32,157)
  26. Title with date in Excel (31,265)
  27. Population Pyramid with Excel (30,882)
  28. XLS vs XLSX file format? (30,661)
  29. How to Link Excel to Google Maps (28,202)
  30. VLOOKUP to the left in Excel (28,115)

Exercise: Find the products that have reach the stock limit

The IF function allows you to display different results depending on a logic test.

This exercise will show you how to display an alert when the stock of products is below the limit.

Quizz stock warning cover

This quiz must be completed in 10 minutes.
MVP_logo_2017

Recent Posts