if negative figure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zul - 29 May 2008 13:14 GMT

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

Reply to this Message

Dennis - 29 May 2008 13:20 GMT

if your 2 cells are A1 & A2

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

> I want to how to put a formula for the beow requirement.
>
[quoted text clipped - 4 lines]
>
> Zul

Reply to this Message

Zul - 29 May 2008 13:26 GMT

Thanks Dennis

> if your 2 cells are A1 & A2
>
[quoted text clipped - 8 lines]
> >
> > Zul

Reply to this Message

Teethless mama - 29 May 2008 13:25 GMT

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

> I want to how to put a formula for the beow requirement.
>
[quoted text clipped - 4 lines]
>
> Zul

Reply to this Message

Dave - 29 May 2008 15:51 GMT

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.

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

Reply to this Message

Stephen Bye - 29 May 2008 20:36 GMT

> 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.

Reply to this Message

Dave - 31 May 2008 16:19 GMT

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.

> 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.

Reply to this Message