Negative value

F

Felipe

How can i change the negative result of a formual into cero "0".
PS: dont want to use the If apliation.

thanks in advance.
 
J

Jacob Skaria

One way is to handle that with IF condidtion as below

=IF(formula<0,0,formula)

If formula is

=SUM(A1:C1)
modify that to

=IF(SUM(A1:C1)<0,0,SUM(A1:C1))
 
R

Rick Rothstein

If you don't want to use IF, then you can use MAX instead...

=MAX(0,<<your current formula goes here>>)
 
D

David Biddulph

For reasons which aren't clear, the OP said "dont want to use the If
apliation.", so perhaps you could change your
=IF(SUM(A1:C1)<0,0,SUM(A1:C1)) to =MAX(SUM(A1:C1),0) ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
Add "+" plus symbol for a positive percentage 4
XIRR 1
Negative value to positive 13
how to get a range of cells rounded off to the nearest value? 3
XIRR Giving Negative Number on Positive Cash Flow Stream 11
Dividing - Negative Number by Zero 5
IF Statement accepting only positive values 1

Top