Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
FLOOR function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR function in Microsoft Excel. Description. Rounds number down, toward zero, to the nearest multiple of significance. Syntax. FLOOR (number, significance) The FLOOR function syntax has the following arguments: Number Required. The numeric value you want to round. Significance Required.
COUNTIF function - Microsoft Support
COUNTIF function. Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says:
Aggregate data from a column (Power Query) - Microsoft Support
Using Power Query, you can aggregate one or more columns of a related table. For example, you can aggregate the sum of order details for each order. Data Preview of the Orders table in the Northwind OData feed.
Convert numbers into words - Microsoft Support
Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.
ROUND function - Microsoft Support
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND (A1, 2) The result of this function is 23.78.
Manage Data Preview (Power Query) - Microsoft Support
Control Data Preview in the Power Query Editor: ways to view data, column profiles, and options that impact performance.
Display numbers as fractions - Microsoft Support
Use the Fraction format to display or type numbers as actual fractions, rather than decimals. If no fraction format is applied to a cell, and you type a fraction such as 1/2, it will be formatted as a date. To display it as a fraction, apply a Fraction format, and then retype the fraction.
Create holiday decorations, cards, gift tags, and more
Discover what you can create for your holidays, right within Office. For more tips and tools, see the complete holiday template collection or watch holiday how-to videos. Create your own holiday cards. Make professional-looking, custom seasonal greeting cards.
Insert pictures - Microsoft Support
Insert pictures. Windows macOS Web. Do one of the following: Select Insert > Pictures > This Device for a picture on your PC. Select Insert > Pictures > Stock Images for high quality images or backgrounds. Select Insert > Pictures > Online Pictures for a picture on the web.