ABS of cell on another page??

G

Geoffery Mihles

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
 
G

Geoffery Mihles

=ABS(Sheet3!E1)

Could this help??
Click to expand...

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
 
R

RaymundCG

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!
 
P

Peo Sjoblom

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
 
Top