hello

I want to calculate two cells, and when the outcom is positive then just
show the calculation. On the other hand when the calculation is negative it
must give 0 as a result.
So it's never a <0 figure
What do I use.

Thx in advance

=MAX(0,SUM(A1,B1))


just change the calculation part to whatever you are doing.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:f5g0dh$auf$(E-Mail Removed)...
> hello
>
> I want to calculate two cells, and when the outcom is positive then just
> show the calculation. On the other hand when the calculation is negative
> it
> must give 0 as a result.
> So it's never a <0 figure
> What do I use.
>
> Thx in advance
>
>

Don't know what you mean by "calculate two cells", but this will give
you what you want:

=MAX(0,your_calculation)

Hope this helps.

Pete

On Jun 22, 9:14 am, <fder.nos...@home.nl> wrote:
> hello
>
> I want to calculate two cells, and when the outcom is positive then just
> show the calculation. On the other hand when the calculation is negative it
> must give 0 as a result.
> So it's never a <0 figure
> What do I use.
>
> Thx in advance

Hello pete/bob

I think i wrote badly what i want
example:



10-5=5
10-9=1
10-10=0
10-12=0

as soon the outcom is <0 it's given a zero

thx for your help










"Pete_UK" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Don't know what you mean by "calculate two cells", but this will give
> you what you want:
>
> =MAX(0,your_calculation)
>
> Hope this helps.
>
> Pete
>
> On Jun 22, 9:14 am, <fder.nos...@home.nl> wrote:
> > hello
> >
> > I want to calculate two cells, and when the outcom is positive then just
> > show the calculation. On the other hand when the calculation is negative
it
> > must give 0 as a result.
> > So it's never a <0 figure
> > What do I use.
> >
> > Thx in advance
>
>

which is what we both gave you.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:f5g26g$fdo$(E-Mail Removed)...
> Hello pete/bob
>
> I think i wrote badly what i want
> example:
>
>
>
> 10-5=5
> 10-9=1
> 10-10=0
> 10-12=0
>
> as soon the outcom is <0 it's given a zero
>
> thx for your help
>
>
>
>
>
>
>
>
>
>
> "Pete_UK" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
>> Don't know what you mean by "calculate two cells", but this will give
>> you what you want:
>>
>> =MAX(0,your_calculation)
>>
>> Hope this helps.
>>
>> Pete
>>
>> On Jun 22, 9:14 am, <fder.nos...@home.nl> wrote:
>> > hello
>> >
>> > I want to calculate two cells, and when the outcom is positive then
>> > just
>> > show the calculation. On the other hand when the calculation is
>> > negative
> it
>> > must give 0 as a result.
>> > So it's never a <0 figure
>> > What do I use.
>> >
>> > Thx in advance
>>
>>
>
>

You are obviously subtracting one cell from another - assume these are
A1 and B1, then the formula becomes:

=MAX(0,A1-B1)

or maybe:

=MAX(0,B1-A1)

Hope this helps.

Pete

On Jun 22, 9:45 am, <fder.nos...@home.nl> wrote:
> Hello pete/bob
>
> I think i wrote badly what i want
> example:
>
> 10-5=5
> 10-9=1
> 10-10=0
> 10-12=0
>
> as soon the outcom is <0 it's given a zero
>
> thx for your help
>
> "Pete_UK" <pashu...@auditel.net> schreef in berichtnews:(E-Mail Removed)...
>
>
>
> > Don't know what you mean by "calculate two cells", but this will give
> > you what you want:
>
> > =MAX(0,your_calculation)
>
> > Hope this helps.
>
> > Pete
>
> > On Jun 22, 9:14 am, <fder.nos...@home.nl> wrote:
> > > hello
>
> > > I want to calculate two cells, and when the outcom is positive then just
> > > show the calculation. On the other hand when the calculation is negative
> it
> > > must give 0 as a result.
> > > So it's never a <0 figure
> > > What do I use.
>
> > > Thx in advance- Hide quoted text -
>
> - Show quoted text -

(E-Mail Removed) wrote:
> Hello pete/bob
>
> I think i wrote badly what i want
> example:
>
>
>
> 10-5=5
> 10-9=1
> 10-10=0
> 10-12=0
>
> as soon the outcom is <0 it's given a zero

=IF(A1-B1<0,0,A1-B1)

--
Jordon