Formula Help Please

[Iron Ax, Inc.]

Hello I am using MS Excel 2000. I need a little formula help. I think I need
an IF statement.

What I am trying to do is =SUM(C58-2000), but I want my destination cell to
either what i have above or zero. I can't have a negative number.

I know this is simple, but I can't figure it out. Any help will be greatly
appreciated.

John Kitchens

 

[David Heaton]

Hello I am using MS Excel 2000. I need a little formula help. I think I need
an IF statement.

What I am trying to do is =SUM(C58-2000), but I want my destination cell to
either what i have above or zero. I can't have a negative number.

I know this is simple, but I can't figure it out. Any help will be greatly
appreciated.

John Kitchens

Hi John,

Try this

=If (c58-2000<0,0,c58-2000)

Regards

David

 

[Pete_UK]

One way:

=MAX(0,C58-2000)

Hope this helps.

Pete

 

[Iron Ax, Inc.]

Thank you very much David. That did it!

John Kitchens

Hello I am using MS Excel 2000. I need a little formula help. I think I
need
an IF statement.

What I am trying to do is =SUM(C58-2000), but I want my destination cell
to
either what i have above or zero. I can't have a negative number.

I know this is simple, but I can't figure it out. Any help will be greatly
appreciated.

John Kitchens

Hi John,

Try this

=If (c58-2000<0,0,c58-2000)

Regards

David

 

[Roger Govier]

Hi John

One way
=MAX(0,C58-2000)