The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1 ...

Getting the most out of your PC backup. When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier. Your Microsoft account ties everything together, no matter where you are or what ...

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.

如果您執行的是 Windows 10、Windows 8.1 或 Windows 8，在執行系統檔案檢查程式之前，請先執行收件匣部署映像服務與管理 (DISM) 工具。. (如果您執行的是 Windows 7 或 Windows Vista，請跳至步驟 3.) 輸入下列命令，然後按下 Enter。. 可能需要幾分鐘的時間才能完成命令作業 ...

Select Start , type device manager, then select it from the search results. Find the problem webcam from the list of devices shown in the Device Manager. It should appear either under Cameras or Imaging devices. Right-click the webcam device and select Update driver. Select Browse my computer for drivers.

How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.

There are four ways to open Snipping Tool: Select the Start button, enter snipping tool, then select Snipping Tool from the results. Press Windows logo key + Shift + S for a static image snip. Press Print Screen ( PrtSc ) for a static image snip. Press Windows logo key + Shift + R for a video snip.

To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.

Pick the file or folder you want to share by selecting its circle icon. Note: Sharing multiple items at the same time is not available. Instead, you can add the things you'd like to share to a folder and then share the folder. If you're using List view, select the circle on the left side of the item.

Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.