is there a function to change negative values to zero?
 

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero

is there a function to change negative values to zero?
 

Since this is a class assignment, I'll give a suggestion but no solution.
Have you tried using a "worksheet_change" event?

"B-manninja" wrote:

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero

is there a function to change negative values to zero?
 

If the value is derived from a formula you can use the
MAX Worksheet Function to change the value
For more information on change events see
http://www.mvps.org/dmcritchie/excel/event.htm

"Barb Reinhardt" wrote in message
...
Since this is a class assignment, I'll give a suggestion but no solution.
Have you tried using a "worksheet_change" event?

"B-manninja" wrote:

I am working on an assignment for class and wondered if you could change
negative values in excel to zero without actually typing in the zero