Formula Help Please

  • Thread starter Thread starter Iron Ax, Inc.
  • Start date Start date
I

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
 
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
Click to expand...

Hi John,

Try this

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

Regards

David
 
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
Click to expand...

Hi John,

Try this

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

Regards

David
 
Back
Top