software

I have a worksheet with multiple pages,
I would like to, if the value of a cell on another page is negative have my
cell return an ABS of that number to the new page.

TIA
Geoffery


=ABS(Sheet3!E1)

Could this help??--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=543151davesexcel gt; wrote
in :

gt;
gt; =ABS(Sheet3!E1)
gt;
gt; Could this help??
gt;
gt;

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

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!E1lt;0,ABS(Sheet3!E1),0)

Hope this helps!
--
Thanks and kind regardsquot;Geoffery Mihlesquot; wrote:

gt; davesexcel gt; wrote
gt; in :
gt;
gt; gt;
gt; gt; =ABS(Sheet3!E1)
gt; gt;
gt; gt; Could this help??
gt; gt;
gt; gt;
gt;
gt; Thanks Dave,
gt; I wa sable to do that,
gt; But what I need is to have the value returned in ABS only of it's negative.
gt; Otherwise the result needs to be 0
gt;
gt; Thank you
gt;

Another way

=ABS(MIN(0,E1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;RaymundCGquot; gt; wrote in message
...
gt; Hi Geoffery!
gt;
gt; Here's a slight modification/extension from the earlier post (if I got
gt; your
gt; idea right)...
gt;
gt; {example only}
gt; Assuming you are in sheet 1 and the data of interest is in Sheet3 E1, you
gt; might use the ff formula
gt;
gt; =IF(Sheet3!E1lt;0,ABS(Sheet3!E1),0)
gt;
gt; Hope this helps!
gt;
gt;
gt;
gt; --
gt; Thanks and kind regards
gt;
gt;
gt; quot;Geoffery Mihlesquot; wrote:
gt;
gt;gt; davesexcel gt;
gt;gt; wrote
gt;gt; in :
gt;gt;
gt;gt; gt;
gt;gt; gt; =ABS(Sheet3!E1)
gt;gt; gt;
gt;gt; gt; Could this help??
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt; Thanks Dave,
gt;gt; I wa sable to do that,
gt;gt; But what I need is to have the value returned in ABS only of it's
gt;gt; negative.
gt;gt; Otherwise the result needs to be 0
gt;gt;
gt;gt; Thank you
gt;gt;
=?Utf-8?B?UmF5bXVuZENH?= gt; wrote in
:

gt; =IF(Sheet3!E1lt;0,ABS(Sheet3!E1),0)

This one is not working at all, Perhaps I can play around abit with it.

Thank you
Geoffery