Fresh Excel Tips

In this example we will be illustrating how to use the SUMSQ Function. Excel provides the SUMSQ function to sum the squares of the arguments. Here is the syntax that is used for the SUMSQ Function: SUMSQ(number1, number2, …) number1, number2, …: From 1 to 30 arguments that will have their squares summed up. Instead of values, [...]

Excel provides the SIGN function to check the sign of a number. This function returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative. If the user enters text instead of a number, the SIGN function returns the error code #VALUE!. SIGN(number) number: Any real number. To check [...]

This tip explains how to convert an Arabic numeral to a Roman numeral. To get this result, use the ROMAN function, which returns the Roman value as text. Here is the syntax that is used: ROMAN(number, form) number: The Arabic numeral to be converted. form: (optional) A number from 0 to 4 that specifies the type of Roman [...]

In this example, we want to determine whether a column’s index in a range is even or odd, and then fill each odd row with the character “X”. Use the ISODD function in combination with IF and COLUMN() to get the result shown in the image below. If this function is not available and returns [...]

In this example, we need to determine whether a row number in a range is even or odd, and then fill each odd row with the character “X”. Use the ISODD function in combination with IF and ROW() to get the result shown in the image below. If this function is not available and returns [...]

To find out whether numbers are even or odd, use the ISEVEN or ISODD functions. ISEVEN returns TRUE if the number is even and FALSE if the number is odd, while ISODD returns TRUE if the number is odd and FALSE if the number is even. ISEVEN(number) ISODD(number) number: The value to be tested. Non-integer values are truncated. To [...]

In our previous articles, we went over standard functions for rounding up a number. In addition to those, there are other functions available like EVEN and ODD. For example, to round up a number to the nearest even integer, use the EVEN function. Here is the syntax that is used for both the even and [...]

To generate randomized values in a specified range, such as from 1 to 49, use the RANDBETWEEN function. This function returns a random number in the range you specify, returning a new random number every time the worksheet is calculated. If this function is not available and returns the #NAME? error, install and load the Analysis [...]

To generate randomized values Excel provides the RAND function. This function returns a random number greater than or equal to 0 and less than 1. Each time the worksheet is calculated, a new random number is generated. This example generates randomized integer values from 1 to 999 in cells A2:D10 and then replaces the formulas [...]

The SUBTOTAL function can be used to calculate subtotals in a list or database. There are different subtotal operations available that are all covered by just one function. The syntax is provided here. How To use the SUBTOTAL function for a number of calculations: Copy the data shown in columns A and B in the image below. Select [...]