How To: Use the if Function in Excel
Video: . IF function
Video: . IF function
A warning to all of you iPhone users with parents, significant others, and nosy friends: Private Mode in the Safari browser isn't as private as you think. At least, not as private as it used to be back in iOS 7.
If you've seen any videos of aurora borealis, star trails, or a solar eclipse, then you're probably well familiar with time-lapse photography. Whether it's a beautiful moving landscape or a deadly natural disaster, time-lapses show us what would otherwise be hour-long recordings as short and sweet videos.
This is a create creation as a toddler toy. My girl loves this toy, she even wanted to take it to bed at night ... Sometimes, some of the most simple toys are some of the most like toys. This toy is cheap and can be completed in 10 minutes at most.
Everyone enjoys summers more than I do. At least, that's how it seems. While I take pleasure in the decline of clothing covering up my lady friends, I could definitely pass on the heat and absurd air conditioning costs. However, one summer staple that balls above all else is cooking on the grill.
Use a q-tip (ones for little kids will have a larger base, but are not required). Put a few drops of red food coloring in a glass of water and stir it up as necessary. Dip q-tip in red water, get it nice and saturated. Remove q-tip and let sit overnight. Cut q-tip in half, then take a small rectangle of paper, apply glue from glue stick to one side, then make a small fold from a corner and roll (this may take some work). Use scissors to cut down to the correct size. Next rub q-tip's cotton si...
Eczema is a skin condition where skin is extremely irritable and sensitive. Learn how to care for eczema with expert tips in this free health video series.
High blood pressure (hypertension) is a common medical condition that can eventually cause serious health problems such as heart disease, kidney failure, vision problems, stroke, heart attack, and more.
When it comes to fence-building, nobody knows better than Lowe's. And if you're thinking about fencing an area of your home, either for privacy, decoration or busywork, this video series will inform you on everything you need to know. Learn how to choose and plan out your fence, whether it be wood, aluminum or vinyl, then see how to start laying it out and digging the posts. Then move on to the actual installation.
When it comes to working with people, the photographer can face quite a challenge. Everyone has a mind of their own, and with these few tips you will know how to advise your subject so they look fantastic in a picture. Join Erin Manning, professional photographer, as she shows us 5 handy tips for working with people.
Apply two or three coats of mascara, letting dry between each application. On top lashes, always brush the underside, from base to tip. On bottom lashes, brush only the topside. Properly apply mascara.
Tired of sniffing your health away? Are your sinuses driving you mad? Well this video will show you how to create a Master Tonic to live for. This stuff fixes cold, flu, respiratory problems, immune booster, anti allergy, anti bacterial, anti fungal, anti anything that can hurt you... MASTER TONIC...
Bob and Jeremy of the Washington Township Fire Department demonstrate P.A.S.S., which is an acronym to help people remember how to operate a fire extinguisher - Pull/Aim/Squeeze/Sweep. Pull the pin, Aim the nozzle at the base of the fire, Squeeze the handle down, Sweep from side to side at the base of the fire.
PGA Professional Rick Sessinghaus discusses three different tips that can help all golfers, from the amateur level to the tour professionals, can do to help improve their putting. The first tip focuses on improving hand and eye coordination by simply looking at the whole the proper way. The second tip deals with the reading the speed of the greens while putting. Finally the third and final tip helps the learner better read the line of the put. Rick believes following these three tips will hel...
Chances are, you just point, shoot, and share photos and videos on your iPhone without a second thought about how your privacy is affected. It's fairly easy to do so since the Camera and Photos apps that Apple provides seem so innocent. But there are a few things you need to know when it comes to shooting media, sharing it, and even deleting it.
Having a Clostridium difficile infection means stomach pains, diarrhea, fever, and loss of appetite, and if the symptoms weren't bad enough, the disease often reoccurs. Now, new research has found an increased risk of recurrence in people who take medication to treat their stomach acid, gastroesophageal reflux disease, peptic ulcer disease, or stomach discomfort.
Google's new Pixel and Pixel XL flagships are some very powerful smartphones, but as with any high-tech gadget, they're only as capable as the user allows them to be. So if you're a proud new Pixel owner, it's time to bone up on a few new features to help get the most out of your device.
Desserts always taste better when they are sugar-coated—and even more so when they're coated in powdered sugar. In particular, crinkle cookies—cake-y cookies that are chewy on the inside and crispy on the outside—are famous for the powdered sugar that creates their cracked appearance.
As one of the most popular home screen apps on Android, the Google Now Launcher is used by millions of people across the world. The two main reasons behind this success are its integrated Google Now home page and an elegant, easy-to-use design.
Welcome back! In the last round of python training, we talked about tuples and dictionaries. We'll be diverging again and talking about logical operators as well as membership operators. These are used very similiar to booleans, so if you haven't read that, I suggest you do so first.
Between sharp knives and slippery produce, basic meal prep can be an absolute massacre. Even the most professional knife-wielders don't stand a chance if they're working on unstable surfaces.
Ever watched Netflix on your phone only to realize an hour later that you forgot to turn Wi-Fi on? That's a whole lot of data used.
My reliance on autocorrect has made me a horrible speller. I take it for granted that it'll catch all my mistakes, but it only ends up making matters worse (especially when it inadvertently makes correct words wrong). So instead of relying on autocorrect to fix typos, why not try to completely prevent mistakes from happening in the first place?
The first few times I posted on some of the Android forums out there, I asked things like "Does anybody how I can make my phone do this or that?" Without fail, the responses to these types of questions were always one word—Tasker.
While it can be argued that Google Chrome is generally a better browser, iPhone users tend to remain loyal to Safari. But one feature that gives Chrome the upper hand is its ability to recognize the language on any given page and offer you an option to translate it to your native language.
With the release of Jelly Bean, Chrome became the default web browser on Android. The wildly successful desktop browser was now fully entrenched in the world's largest mobile operating system.
In this how-to video, you will learn how to make Cobra-style paper airplane. All you need is a regular piece of paper. This style is useful for hitting targets or flying straight. Fold the paper in half vertically and unfold. Take the top corner of the paper and fold it to the edge of the middle crease. Repeat with the other corner. Take the tip of the center and fold it to the horizontal line created by the folded corners. Make sure you make tight folds. Open it up and make a fold horizontal...
Rose Levy Beranbaum demonstrates how to make a simple and delicious chocolate ganache frosting, and gives tips for frosting the cake. Only two ingredients are needed - 12 ounces of semi-sweet or bittersweet chocolate, whichever you prefer, and 1 2/3 cups of heavy cream. Grate the chocolate in the food processor, then with the motor running pour in the cream, and it’s done. However, it needs to sit for a few hours to thicken. You can refrigerate it but don’t stir it.
Felt food is a great substitute for unsafe toys for children. A real life mom gives tips in this video on how to create great felt food that her children absolutely love playing with! The instructions are easy: Use wool or wool-blend felt instead of craft felt; it feels nicer. The first thing you need to do is cut out the felt patters provided on the website. You will need a red half circle, and a four pointed star. Seeds can be added by tying French knots using white thread. The next step is...
Are you playing through Dark Souls and having flash backs to all those times you died in Demon Souls? IGN is here to help you with several tips and tricks on surviving. This guide shows you good spots to grind, what gift to pick for your character, and where to get the Sorcerer's Catalyst item that will allow you to cast magic in the game, even if you aren't a magic user.
There's a big, BIG difference between professional cake decorating and what most of us do after we've baked a cake - i.e., slathering a bunch of storebought icing onto our cupcakes with a spatula and patting the clumps down.
Now that the holiday season is right at our doorstep, you'll probably be doing a lot of blending, cutting, brining, and baking over the next two months. Which means it's more important than ever that all your kitchen utensils are in tip top shape.
In this video, we learn how to paint your nails in a pink and purple French manicure. Start off by cleaning your nails from any dust, debris, or colors. Then, you will paint on black to one side of your nail with a fine tip brush. After this has dried, paint pink on the other side of the nail, a pink glitter color would be the best. Next, you will wait for this to dry and then paint on a white line in between these two colors. From here, you will apply three small rhinestones with nail glue t...
In this tutorial, we learn how to prepare the bird for buttermilk fried chicken. First, take off the wing tips, then de-joint the wings. After this, take off the wings and thighs from the body and the legs. Now, use a large clever to remove the breasts from the chicken. Now, season the pieces with white pepper, dried herbs, cayenne pepper, paprika, salt, and pepper. After this is tossed, top this with buttermilk and let it soak for 6 hours. Now, prepare flour with salt, white pepper, garlic s...
In this tutorial, we learn how to draw a tree branch. Start out drawing two lines for the trunk of the tree. Work these lines up until you reach the top where the branches are located. Then, draw outward lines that will be the branches. Do not make all of them the same size. You want this to look realistic, so make them all vary in size. Draw small lines at the tip of every branch to make it look like wood coming off of them. When finished, add in lines along the branches to show bark on them...
In this video, we learn how to make a rose out of a bar napkin. First, take your pointer finger and thumb and get them moist. Then, grab the upper right hand corner of the napkin and gently roll it over. After this, keep rolling it towards yourself until you have rolled the entire thing. Next, roll then entire napkin up in a cylinder and find the tip in the middle. Grab this and then twist it to bring it out to the top. then, go down a few inches and squeeze and twist. Flare out the petals an...
Kevin Richards gives a you a great lesson on warming up your singing voice. What should you do to warm up your voice? How often? How long? Well, it all depends on the type of person and how much you have spoken throughout the day. These tips for warming up (and warming down) your voice are definitely helpful, like warming up from the top of the scale, down.
In this video, we learn how to wear a scarf by creating contrast and texture. A squared shaped scarf with contrasting patterns will look great with anything that you are wearing. To wear this, make it into a triangle, then tie the ends together around the back of the neck. Then, you can let the scarf hang down on the front to add a texture to your look. A solid color scarf is also great if you are wearing a simple top to add a splash of color. You can tie this around the neck one, then let th...
In this Spirituality video tutorial you will learn how to palm read with Peter John. If the heart line, the first line on top of the palm, is well formed and curves around towards the center of the first finger, the person is quite good and balanced. If the head line is quite long along the palm and bends towards the lower part of the palm, the person is more practical and mathematical. When you see more than one line on the mount of Apollo or the mount of Sun, the person could take more than...
In order to paint palm trees on your nails, you will need the following: white matte base nail polish and a variety of other colors. You will need toothpicks, if you do not have fine brushes in your polish.