ExcelBanter - Negative Numbers to Zero

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Negative Numbers to Zero (https://www.excelbanter.com/excel-worksheet-functions/102063-negative-numbers-zero.html)

MSG K

Negative Numbers to Zero

I am looking for a way to have negative numbers show up as 0. Any
clue???:confused:

--
MSG K
------------------------------------------------------------------------
MSG K's Profile: http://www.excelforum.com/member.php...o&userid=36914
View this thread: http://www.excelforum.com/showthread...hreadid=566270

Toppers

Negative Numbers to Zero

=MAX(A1,0)

Or

=If(A1<0,0,A1)

HTH

"MSG K" wrote:

I am looking for a way to have negative numbers show up as 0. Any
clue???:confused:

--
MSG K
------------------------------------------------------------------------
MSG K's Profile: http://www.excelforum.com/member.php...o&userid=36914
View this thread: http://www.excelforum.com/showthread...hreadid=566270

All times are GMT +1. The time now is 08:01 AM.