Hello!
In a cell with a SUM I need to put 0 when the sum is negative.
For example, X=Z+Y+W. If X>=0 ==> I want to put the right value.
BUT IF X<0 I want to have 0 in the cel!
How could I do this?
thanks,
marco

=IF(G4+G5+G6)<0,0,(G4+G5+G6))

=IF(SUM(G4:G6)<0,0,SUM(G4:G6)) if contiguous

=IF(SUM(G4,G5,G8)<0,0,SUM(G4,G5,G12)) if non-contiguous


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 07:22:04 -0800 (PST), marco.nickoli@gmail.com wrote:

>Hello!
>In a cell with a SUM I need to put 0 when the sum is negative.
>For example, X=Z+Y+W. If X>=0 ==> I want to put the right value.
>BUT IF X<0 I want to have 0 in the cel!
>How could I do this?
>thanks,
>marco

=MAX(0,G1+G2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<marco.nickoli@gmail.com> wrote in message news:690135e5-a5ef-4170-8947-f0745342e6bc@s36g2000prg.googlegroups.com...
| Hello!
| In a cell with a SUM I need to put 0 when the sum is negative.
| For example, X=Z+Y+W. If X>=0 ==> I want to put the right value.
| BUT IF X<0 I want to have 0 in the cel!
| How could I do this?
| thanks,
| marco