Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

ROUND

Formatting Condition is a Calculated Value

By Jeff Lenning | July 30, 2024 |

Hello and welcome to this tutorial on how to use conditional formatting with a calculated value in Excel! Today, we’re going to dive into the following question: How do you conditionally format a cell when the condition is based on a calculated value? Let’s jump right in! Video Tutorial Let’s work through the concepts sequentially…

Read More

Round to N Digits or Multiples

By Jeff Lenning | November 7, 2023 |

In this tutorial, we will explore different methods of rounding values in Microsoft Excel. We will learn how to use various rounding functions and understand the difference between rounding through formulas and changing the displayed value through formatting. We will round by the number of decimals or whole numbers as well as to the nearest…

Read More