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
|