Another way

=ABS(MIN(0,E1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"RaymundCG" wrote in message
...
Hi Geoffery!

Here's a slight modification/extension from the earlier post (if I got
your
idea right)...

{example only}
Assuming you are in sheet 1 and the data of interest is in Sheet3 E1, you
might use the ff formula

=IF(Sheet3!E1<0,ABS(Sheet3!E1),0)

Hope this helps!



--
Thanks and kind regards


"Geoffery Mihles" wrote:

davesexcel
wrote
in :


=ABS(Sheet3!E1)

Could this help??



Thanks Dave,
I wa sable to do that,
But what I need is to have the value returned in ABS only of it's
negative.
Otherwise the result needs to be 0

Thank you