Replace the minus value
 

Hi freindz,

I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.

Kindly suggest me, how can it possible.

Regards,

Rajiv

Replace the minus value
 

To use a formula:
=if(a1<0,0,a1)

Regards,
Fred

"Rajiv" wrote in message
...
Hi freindz,

I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.

Kindly suggest me, how can it possible.

Regards,

Rajiv

Replace the minus value
 

If say A1 thru A1000 have both positive and negative values, then in an
unused column enter:

=IF(A1<0,0,A1) and copy down. Then copy the new column and
paste/special/values back onto column A.
--
Gary''s Student - gsnu201001


"Rajiv" wrote:

Hi freindz,

I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.

Kindly suggest me, how can it possible.

Regards,

Rajiv

Replace the minus value
 

.... or =MAX(0,A1)
--
David Biddulph


"Fred Smith" wrote in message
...
To use a formula:
=if(a1<0,0,a1)

Regards,
Fred

"Rajiv" wrote in message
...
Hi freindz,

I am working in one sheet. There are some negative (minus) value in some
cell. I want to replace it with zero with the use of formula.

Kindly suggest me, how can it possible.

Regards,

Rajiv