if negative figure

[Zul]

I want to how to put a formula for the beow requirement.

sum of two cells, if i get a postive asnswer I want to display it, if I get
a negative answer i want to display 0(zero)

Thanks

Zul

 

[Dennis]

if your 2 cells are A1 & A2

=IF(SUM(A1:A2)<0,0,SUM(A1:A2))

 

[Teethless mama]

=MAX(SUM(A1:A2),0)

 

[Zul]

Thanks Dennis

if your 2 cells are A1 & A2

=IF(SUM(A1:A2)<0,0,SUM(A1:A2))

 

[Dave]

Hi TM,
Jumping in here,
I hadn't thought of using the MAX function for this issue. I like the way it
eliminates the need to repeat the main formula, which has to be done when
using the IF function.
On occasion, I have quite a long formula which sometimes returns an error,
depending on the presence, or not, of data in the contributing cells. I end
up using the something like the following:
IF(ISERROR(Quite Long Formula)=True,"",Quite Long Formula)
Is there a way to do this without having to repeat the Quite Long Formula,
as you did with the MAX function in the original question?
Regards - Dave.

 

[Stephen Bye]

On occasion, I have quite a long formula which sometimes returns an error,
depending on the presence, or not, of data in the contributing cells. I
end
up using the something like the following:
IF(ISERROR(Quite Long Formula)=True,"",Quite Long Formula)
Is there a way to do this without having to repeat the Quite Long Formula,

Put Quite Long Formula into Some Other Cell.
Then use:
=IF(ISERROR(Some Other Cell),"",Some Other Cell)
That way, your formula only needs to be evaluated once.

 

[Dave]

Hi Stephen, Thanks for that idea. Don't know why I don't think of these
things myself. This forum is an amazing wealth of knowledge and ideas.
Regards - Dave.

 

[Dave]

Hi Dana,
Thanks for that info. That's a very useful function. I still use XL2000, so
that'll be something to look forward to when I eventually upgrade.
Regards - Dave.

:

 

[Dave]

Hi Dana,
Thanks for that. For some reason I never think of using custom functions. So
useful!
Regards - Dave.