home | about | newsletters | contact | advertising | shop | radio | courses | widget | site map

Helping Normal People Get Their Geek On And Live The Digital Lifestyle

Is It Possible To Make $141,657.15 While Playing With Your PC?
» Learn More About PCMech Premium Program
Big Things Are About To Happen Here

Login: Password: Remember me

Some More Functions

This entry is part 8 of 11 in the series Introduction to Spreadsheets Using Excel

Posted Jul 7, 2008 by Rich Menga  

Mathematical & Trigonometric Functions

image

Abs() :This function is used to return the absolute value of a number.
Syntax : Abs(number)
Example : =Abs(A1) , Abs(-54)
Result : 5 54

Sqrt() : This function is used to return the square root of a number.
Syntax : Sqrt(number)
Example : =Sqrt(A5) , Sqrt(D1*5)
Result : 5 10

Please Login or Register to read the rest of this article. Gold/Silver Membership required.

Posted In: Series, Software

Got The Newsletter?

Exclusive PCMech Content. Sign up and receive our free report: 20 Tips For Becoming a Technology Power User.

NAME:
EMAIL:

PCMech Highly Recommends...

This is the "kitchen sink" e-book for computer maintenance and repair. A jam-packed 346 pages. As Monte Russel (the author) says in his e-book, "Computers have always been complex, but if a guy that grew up out in the boonies in Wyoming can fix 'em, you can also!" Monte is a 20-year veteran of the U.S. Air Force. Afterwards, he served a long career as a computer repair tech and network administrator. LEARN MORE

Best of PCMech