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: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=543151

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

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

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

?B?UmF5bXVuZENH?= wrote in
:

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

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

Thank you
Geoffery