ABS | |
| Description : | Microsoft Excel ABS function returns the absolute value of a number. ABS function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the ABS function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. |
| Syntax : | abs(number) |
| Parameter | Number: a numeric value used to calculate the absolute value. |
| Example | abs(-512.23) -> Result: 512.23 |
| abs(512.23) -> Result: 512.23 |
| |
REPLACE | |
| Description : | REPLACE function replaces a sequence of characters in a string with another set of characters. |
| Syntax : | Replace ( string1, find, replacement, [start, [count, [compare]]] ) |
| Parameters : | string1: string to replace a sequence of characters with another set of characters.
Find: String to be searched in string1
replacement: Replacement string for string1
start: This is the position in string1 to begin the search. If this parameter is omitted, the REPLACE function will begin the search at position 1.
compare: vbBinaryCompare = 0 .
vbTextCompare = 1. Textual comparison
vbDatabaseCompare = 2
count: This is the number of occurrences to replace. If this parameter is omitted, the REPLACE function will replace all occurrences of find with replacement. |
| Example | Replace("ReplaceDemo", "e", "a", 4) -> Result: lacaDamo |
| Replace("ReplaceDemo", "e", "a") -> Result: RaplacaDamo |