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.

Which Of These Traits Applies To YOUR Computing Life?...

Leave a Reply