Prev: Counting formula
Next: Excel Logical IF function
From: Jay M 0425 on 19 Mar 2010 23:39
I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks
From: Teethless mama on 19 Mar 2010 23:45
=MAX(C1-C2,)


"Jay M 0425" wrote:

> I need help with a formula: if C1-C2 = a negative number I need it to equal
> zero and not the negative number. How do I do this?
>
> It is probably really simple but I cannot wrap my head around it.
>
> Thanks
From: T. Valko on 20 Mar 2010 00:19
Try this...

=MAX(0,C1-C2)

--
Biff
Microsoft Excel MVP


"Jay M 0425" <JayM0425(a)discussions.microsoft.com> wrote in message
news:3CD4CDB1-9BF8-4DC2-AB18-6C561637FE12(a)microsoft.com...
>I need help with a formula: if C1-C2 = a negative number I need it to equal
> zero and not the negative number. How do I do this?
>
> It is probably really simple but I cannot wrap my head around it.
>
> Thanks


 | 
Pages: 1
Prev: Counting formula
Next: Excel Logical IF function