CODEWITHSUNDEEP
excelexcel-2010
PRVS
PRVS

Reputation: 1690

Excel - Negative numbers to zero

I have a cell with a negative number, but I want to put 0 instead of negative number. How can I make this? Any help?

Upvotes: 0

Views: 940

Answers (2)

Harun24hr
Harun24hr

Reputation: 37145

You can also use

=IF(A1<0,0,A1)

Upvotes: 1

JMR
JMR

Reputation: 765

if you write =MAX(0;your formula)

Upvotes: 1

Related Questions