Excel Help

CFA General
#1

Sorry to bother, does anyone know when constructing a fomula in excel how to take the absolute value of a cell in that fomula? I know I could multiple by (-1) but then when the numbers go positive I am back in the same spot. Much thanks

#2

=abs()

#3

=ABS()

#4

thanks

#5

yup - abs() is the way to go. even if you didn’t know this, you could build in your own logic using: if(x<0, x*(-1),x)

#6

It must have taken longer to post the question on here than to have looked it up using Excel Help.

#7

sw74 Wrote: ------------------------------------------------------- > It must have taken longer to post the question on > here than to have looked it up using Excel Help. Very beneficial post. Hope you got something out of it.

#8

I’m more than happy to help someone if they’ve got a problem with Excel but it annoys me when they won’t even take the time to have a look at the help file to see if they can figure it out before asking.