Nesting an IF, Then statement

Step 1 – Create a list of your cities

Step 2 – Create a picklist using cells from above
·    Select a cell for your picklist (I used A8) and click Data > Validation > Settings
·    Allow: List
·    Source:  For my example, A1 through A4.  (click the Source field and drag down your list)
·    Click OK.  Now your list is available.

Step 3 – Select a cell to display your statement (I use  D8)

Step 4 – Copy and paste the following into that cell

=IF(A8=A1,"Dallas Address Here",IF(A8=A2,"Fort Smith Address Here",IF(A8=A3,"Atlanta Address Here",IF(A8=A4,"OKC Address Here",""))))

Now, when you select Dallas from the drop down box, an address will populate.

  

Note – You will need to tweak the formula by changing the names in parenthesis.  For example, “Fort Smith Address Here” becomes “212 Elm Street”.

How to Save and Convert YouTube Movie Files

If you are wanting to  save a video from youtube and wish to be able to play it on your Mac or PC, follow these simple steps:

1. Go to www.keepvid.com which will allow you to paste the link to of the youtube video you want to save. When you paste it there, then click the download button.
2. It will allow you to download a FLV version of the video. Download it
3. If that format is not playable on your computer, I would suggest you go http://media-convert.com/ and select the input format (FLV) and output format to be what you need. You will be using that website to convert your FLV video that you downloaded in step 2. Be patient, as it will take several minutes to upload the video, and then convert it to the format you specify.
4. If you want to play it on a PC, then output the format to AVI or WMV. If you want to play it on a Mac, then output to MOV format.

Post questions in the comments. Thanks for reading!

How to Create Pictures From Videos

The simplest way to create a picture or still images from a video file is to literally take a picture of the video at the place you would like a photo. See below:

For PC users:
1. Open the video file and maximize it to full screen. If the video looks too blurry, then drag the video to be large enough where the quality of the picture shown is still acceptable.
2. Pause the video at the place you would like a picture.
3. Press the button on your keyboard that says Print Scrn = SysRq (it is in the upper right hand corner of most keyboards)
4. Open the application called MS Paint. On a PC it should be in the start menu usually in accessories.
5. Inside of Paint, right click in the white area and select Paste
6. You should now see a picture of the screen that you took when the video was playing. You can crop it by using the select tool. Select just the video area, then press edit>copy, then delete everything and select edit>paste
7. Click File>Save AS and select the type as JPEG

Questions? Post in the comments. Thanks for reading!