Using IF with AND, OR, and NOT functions in Excel
WebLess 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)
Connect a wireless display to your Windows PC - Microsoft …
WebWirelessly connect your PC to a monitor, projector, or other kind of external display that is connected to a WiGig dock. Turn on the TV or projector. Turn on your WiGig dock and make sure it's connected to the display. Make sure your PC supports WiGig and that it's turned on.
Insert mathematical symbols - Microsoft Support
WebIn Word, you can insert mathematical symbols into equations or text by using the equation tools. On the Insert tab, in the Symbols group, click the arrow under Equation, and then click Insert New Equation. Under Equation Tools, on the Design tab, in the Symbols group, click the More arrow.
Create conditional formulas - Microsoft Support
WebLess Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND , OR , NOT , and IF functions to create conditional formulas.
SUMIFS function - Microsoft Support
WebSyntax. SUMIFS (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) =SUMIFS (A2:A9,B2:B9,"=A*",C2:C9,"Tom") =SUMIFS (A2:A9,B2:B9,"<>Bananas",C2:C9,"Tom") Examples. To use these examples in Excel, drag to select the data in the table, right-click the selection, and pick Copy.
Reduce the file size of your Word documents - Microsoft Support
WebSee Also. Reduce the file size of your Excel spreadsheets. Reduce the file size of your PowerPoint presentations. Learn how to reduce the size of your Word documents.
Reduce the file size of a picture in Microsoft Office
WebWith your file open in your Microsoft Office application, select the picture or pictures that you want to compress. Under Picture Tools, on the Format tab, in the Adjust group, select Compress Pictures. If you do not see the Picture Tools - Format tab, make sure that you selected a picture.
SUMIF function - Microsoft Support
WebLess You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.
Display or hide zero values - Microsoft Support
WebHide or display all zero values on a worksheet. Go to File > Options > Advanced. Under Display options for this worksheet, select a worksheet, and then do one of the following: To display zero (0) values in cells, check the Show a zero in …
Keeping leading zeros and large numbers - Microsoft Support
WebExcel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15, in order to allow formulas and math operations to work on them. This article deals with how to keep your data in its original format, which Excel treats as text. Convert numbers to text when you import text data.
Change screen brightness in Windows - Microsoft Support
WebPress and hold (or right-click) the display adapter name, then select Update driver and follow the instructions. Get steps for how to change screen brightness in Windows.
Skip to content