In File Types

Excel is an incredibly versatile program. It can be used to achieve very simple ends, such as recording your income each month; or it can be used for complex databases and dat…a analysis. Data that is entered into a spreadsheet can be processed and manipulated in many types of ways, thanks to Excel's extensive selection of functions. SIGN is one of Excel's simpler functions. It returns the sign of any whole number provided as an argument.Excel allows data to be processed in many ways thanks to a large selection of function types. Some functions are used regularly, such as SUM, which simply sums all the values in an array. Other functions have very specific applications, and are more likely to be used by developers. SIGN, despite being a very simple function to use, falls into the latter category. Returning the sign of a number will mainly be of use in complex mathematical processes."Sign" is a mathematical concept. All non-zero numbers have a sign. A number greater than zero is positive. A number less than zero is negative. Zero is signless. A number's sign is often denoted through the use of the plus symbol for positive numbers (+) and the minus symbol for negative numbers (-).SIGN is one of Excel's most basic functions. It is used to return the sign of a number. It accepts a single whole number as an argument. It will output one of three responses, based on the argument provided. If the argument evaluates to zero, then the function returns "0." If the argument evaluates to a negative value, the function returns "-1." If the argument evaluates to a positive value, the function returns "1." To insert the SIGN function into an open workbook file (spreadsheet), click on any cell to make it active. Type the function as: =SIGN([number]). The equals sign at the start of the function is important, as it lets Excel know that you have entered a function rather than a text string. The value of "number" is the argument you are evaluating. This could be a hard-coded number, or it could be a cell reference. It is also possible to use the SIGN function as an argument for other functions.As a simple example, imagine you have the value 50 in cell A1. To evaluate the sign of that value, you would use the formula: =SIGN(A1). The result would be "1," as the value is positive. If you want to, you can also use SIGN as part of more complex formulas. For example, if you want to convert the numerical output of SIGN into words, you could use a formula such as: =IF(SIGN(A1)=1,"positive","zero or less"). In this example, if the value of A1 is positive, the function will display the word "positive," otherwise it will display "zero or less."Excel has an incredibly diverse range of functions. Some of them are very useful in many situations, and you will find yourself using them often. Other functions have much narrower applications, and you may never need them at all. The SIGN function is very simple to use, as it accepts a single whole number as an argument, and then returns the sign of that number."Sign" is a mathematical concept. All non-zero numbers have a sign. A number greater than zero is positive. A number less than zero is negative. (MORE)

In Functions

Microsoft Excel spreadsheets are easy to use because of the many built-in functions. One such useful feature is the ceiling function. You can use it to round up numerical valu…es as desired. Its most common application is in dealing with prices, where nickels and pennies are rounded off to dimes.The ceiling function is used to round off a numerical value with or without a decimal part. You can specify the closest multiple to which the rounding off must be done. This is always done on the higher side by default. There are a maximum of three variables within this Excel function. Of these, only the first variable is mandatory.To apply the ceiling function to a particular cell in an Excel spreadsheet, type "= CEILING (number, significance)." The first variable inside the brackets is the numerical value that needs rounding off. The function's second variable is its significance; the number will be rounded off to the nearest multiple of this value. You can assign integer or decimal values to the significance variable. If no value is specified, a default value of 1 is used to round up the number to the nearest integer. Just like positive numbers, negative numbers are generally rounded off on the upper side, which is closer to zero. For example, -3.4 would be rounded off as -3. You can change this by assigning a value of 1 to a third variable, called mode. With this, the resultant value after rounding off will be -4. Note that the mode does not apply to positive numbers.You may not always remember the syntax of the ceiling function. The easier option is to choose it from the drop down menus provided in Excel. You need to choose "Math & Trig" from the menu, and then select "ceiling" from the list. The required function will open up in a dialog box. Here, you can replace its variables with the appropriate values. Once you have applied this function to a particular cell, it can be extended across that row or column by dragging the cell from its bottom-right corner.CEILING (43.63, 0.10) is an example showing how this function works. Its result will be 43.7 even though 43.63 is numerically closer to 43.6. Adding the mode variable as 1 to this function will not change its result. In the case of negative numbers, CEILING (-43.63, 0.10) will give you -43.6. Here, you can change the direction of rounding off by adding the mode. So, CEILING (-43.63, 0.10, 1) gives -43.7. Microsoft Excel's functions help you to work with numerical values in many ways. Trailing decimal places can get tedious, especially when their length varies between numbers. The ceiling function is very useful in rounding off these values to a fixed number of decimal places or to the nearest integer. You can then sum up the rounded numbers or use them in other formulae.Microsoft Excel's functions help you to work with numerical values in many ways. Trailing decimal places can get tedious, especially when their length varies between numbers. The ceiling function is very useful in rounding off these values to a fixed number of decimal places or to the nearest integer. (MORE)