The excel absolute formula returns the value of the referenced cell as a positive value whether it is positive or negative. So take the following two formulas: =ABS(20) will display the value 20. =ABS(-20) will also display the value 20.
Sunday, October 28, 2012
Subscribe to:
Post Comments (Atom)
www.cineclouds.com. Powered by Blogger.
Popular Posts
Blog Archive
-
▼
2012
(38)
-
▼
October
(22)
- Using Weekday function in Excel
- Using Tomorrow date function in Excel
- Year function
- Month function in Excel
- Using Addition in Excel
- Yesterday's Date Function in Excel
- One week ago date function in Excel
- Current Date Function in Excel
- Absolute formula in Excel
- Division
- Multiplication in Excel
- Using Subtraction in MS Excel
- Date and Time function in Excel
- Using IF Statements in MS Excel
- IF Search Statement (wildcard if statement)
- IF Statements...continued
- Using IF Statements in MS Excel
- Using Minimum Formula ub Excel
- Using VLOOKUP Exact Match Formula in Excel
- Using Maximum formula in Excel
- Using CountIF Formula in Excel
- Using Sum Formula in Excel
-
▼
October
(22)
0 comments:
Post a Comment