Sure, here are 10 less commonly used Excel formulas along with brief descriptions:
1. **MID**: This function extracts a substring from a string, starting at a specified position and of a specified length.
=MID(text, start_num, num_chars)
2. **CLEAN**: This function removes all non-printable characters from text.
=CLEAN(text)
3. **IMAGINARY**: This function returns the imaginary coefficient of a complex number.
=IMAGINARY(inumber)
4. **TODAY**: This function returns the current date.
=TODAY()
5. **EVEN**: This function rounds a number up to the nearest even integer.
=EVEN(number)
6. **DAYS**: This function calculates the number of days between two dates.
=DAYS(end_date, start_date)
7. **UNICHAR**: This function returns the Unicode character referenced by the numeric value.
=UNICHAR(number)
8. **NETWORKDAYS.INTL**: This function calculates the number of working days between two dates, excluding specified weekends and holidays.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
9. **INFO**: This function returns information about the current operating environment.
=INFO(type_text)
10. **BAHTTEXT**: This function converts a number to text using Thai baht currency format.
=BAHTTEXT(number)
To add the contents of a single cell, you simply reference that cell in your formula. For instance, if you want to add the value of cell A1 to another value, you can use this formula:
=A1
This formula will simply return the value of cell A1. If you want to perform arithmetic operations, such as addition, with the value of cell A1, you would use it within the formula accordingly. For example, if you want to add 5 to the value of A1:
=A1 + 5
This will add 5 to the value in cell A1. You can modify the formula as per your requirements. These formulas can be useful in various scenarios, depending on the specific requirements of your Excel spreadsheet. To add the contents of two cells in Excel, you would use the addition operator (+) within a formula. For example, if you want to add the contents of cell A1 and cell B1, you would write the formula in another cell (let’s say C1) as follows:
=A1 + B1
This formula will add the values in cells A1 and B1 and display the result in cell C1. You can drag this formula down to apply it to multiple rows or across to apply it to multiple columns, adjusting the cell references accordingly.