The Excel Trick to Change Negative Numbers to Zero & Keep Positive Numbers Unchanged

Learn More:- https://www.exceltutorial.net/
============================================================
🧑‍🏫 Statistical Functions Playlist:-    • Statistical Formulas in Excel  
============================================================

Do you ever need to change negative numbers to zero but keep positive numbers unchanged? If so, then you'll love this Excel trick! All you have to do is use a simple formula to convert the negative values to zeroes.

This can be really helpful when you're trying to keep your financial statements in order. Let's take a look at how it's done!

We will use MAX function in this formula, therefore lets see the syntax and understand MAX function in excel as follows;

MAX function in excel is a built-in function that returns the largest value from a given list of arguments. The MAX function ignores empty cells and text values but considers error values.

The generic syntax for MAX function is as follows; =MAX(number_value, [number_value],…)

So coming back to our formula, we will use MAX function to return the largest value from a given list of negative numbers. The formula will be as follows;

=MAX(A:A)

This will convert all the negative numbers in A column to zeroes and leave positive numbers unchanged.

You can also use this formula in other cells by selecting the cell range where you have the negative numbers.

Please watch this video to understand how to use MAX function in excel;

=MAX(A:A) will convert all the negative numbers in A column to zeroes and leave positive numbers unchanged.

You can also use this formula in other cells by selecting the cell range where you have the negative numbers
Table of Content;

00:00 Introduction

00:40 Change Negative Numbers to Zero

09:30 Conclusion



Other Playlists:-

Financial Functions in Excel -    • Financial Function  in Excel  

Cell References in Excel -    • Cell References In Excel  

Logical Functions in Excel :-    • Logical Functions  

Count and Sum Functions in Excel -    • Count And Sum Function  

Learn Data Validation In Hindi:    • Learn Data Validation In Hindi  

Learn Excel Tutorials Online:-    • Learn Excel Tutorials In Hindi  

Excel Analysis Tutorial:    • Excel Analysis Tutorials