Ax | search
Click here to view Ax news from 60+ newspapers.
Bookmark or Share- Using IF with AND, OR, and NOT functions in ExcelIn 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)
- Change the scale of the vertical (value) axis in a chartChange the scale of the vertical (value) axis in a chart. Applies To. By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
- Add or remove titles in a chart - Microsoft SupportYou can add a title to each axis in a chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts. Some chart types (such as radar charts) have axes, but they cannot display axis titles.
- Transpose (rotate) data from rows to columns or vice versaIf you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
- FILTER function - Microsoft SupportThe FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (""). Syntax.
More
