In the modern-day Internet, chat and instant messengers have taken over all forms of communication pushing even the likes of email to the brink of non-existence. One of the most popular among such chat apps is WhatsApp, a truly revolutionary service that has managed to take the entire world by storm.
One of the main draws of WhatsApp has been it’s a ubiquitous and simplistic approach. However, despite its wide reach, WhatsApp remains stuck in one main avenue as it’s popularity has been somewhat restricted by the platforms on which it is available.
Today, however, we seek to correct all that as we head onto our topic on how to install WhatsApp on Mac or PC.
How to Install WhatsApp For Mac or PC?
WhatsApp is one of the fastest-growing social networking sites and messaging sites. As it uses the internet for sending text messages, photos, and other media files, it is much cheaper than a normal texting charge rate. Whatsapp can be used without any Android devices. It can be installed and be used in Windows and Mac devices too.
Whatsapp is basically a phone-based app, so it is ideal for doing Whatsapp using any Android phone or iPhone devices. If you are using Whatsapp through phone, then you can open WhatsApp on your PC too. Here are the ways you have to go through:
At first, download Whatsapp for Android or download Whatsapp for iPhone ( downloading Whatsapp is absolutely free)
#1. Using Whatsapp Web: The Easiest Way for both PC and Mac
It is the most simple way to open Whatsapp on your PC. But you need the Whatsapp app installed on your iPhone or Android phone. It is very easy to open Whatsapp on your PC or Mac by Whatsapp Web. Here are the ways you should follow:
Open any web browser like Internet Explorer, Goggle Chrome, Mozilla Firefox on your PC or Mac.
Open the URL web.whatsapp.com.
On your phone, tap on the WhatsApp icon.
Then go to Menu or Options.
Then select WhatsApp Web.
Tap on the “+” icon you see at the top right corner.
Now scan the QR code shown on the screen by your phone.
After scanning, the Whatsapp web will automatically open your existing Whatsapp account on the PC or Mac. You would be able to see all of your Whatsapp chats and contacts on the Whatsapp web. Though Whatsapp web does not have all the facilities of the phone it almost has everything like desktop alerts to make you know about new texts or incoming calls. You can share photos, videos, etc. You can logout from Whatsapp web when you are done.
But negative points are, you can not receive a call, block any person at Whatsapp, create a group, etc.
#2. By Using ChitChat App
If you do not want to use a tab for WhatsApp web, then ChitChat is a preferable choice for you. This is a Mac app which is a web page wrapper for Whatsapp web. After completion of the download and installation of the ChitChat app, follow the steps of opening the Whatsapp web; as both Whatsapp web and the ChitChat, the app is almost the same.
#3. By Using PushBullet App
Pushbullet is another app that can connect your phone with Mac or PC. Download this app in both your Android and Pc or Mac to use Whatsapp. The ways are:
Download Pushbullet for OS X and install it.
Download Pushbullet for Android and install it.
Sign-in into Whatsapp on both the devices(phone and Mac or PC) with the same account.
For your Android device,
- Open Pushbullet,
- Go to Menu,
- Select Mirroring,
- After that select Show my notifications on my PC,
- Enable the option.
For your Mac,
- Open Pushbullet,
- Go to Preferences,
- Then go to Settings,
- Select Enable Pushbullet Notifications,
- After that check the box. It will enable notifications for all chats and texting apps.
So, from the next time whenever you get a message on WhatsApp, it will notify you on your Mac, to which you can quickly reply or dismiss.
#4. By Using BlueStacks
For Bluestacks, you do not need any previously existing Whatsapp account on your phone. You will have to create a new account here.
Note: The procedure is the same for a Mac and PC, so here we are discussing only for a Mac.
At first, you have to download and install BlueStacks on Mac OS X.
Then run the BlueStacks and sign in into it with your Google account ID.
Find the WhatsApp app in BlueStack and install it on your Mac.
Now start the setup process for setting up Whatsapp. Whatsapp will ask you to provide your phone number. Give the number of the phone where you can receive a regular phone call.
WhatsApp will try to verify the given phone number by sending an OTP through SMS. This may take a few minutes; you have to wait to get the code.
If the attempts are unsuccessful, WhatsApp will try to call you with the verification code. You have to answer the call when Whatsapp calls you, and you will get to hear a verification code. Type it into the Verification Code Box in WhatsApp on BlueStacks on your Mac.
After finishing all the steps mentioned above, you can use Whatsapp for Mac.
By this, we have reached the end of this article today. We hope that this article has helped you in your quest about how to install Whatsapp for Mac or PC.
Moreover, if you are left with any kind of feedback or query, then do let us know by dropping a line in the comments section right below. We would love to hear from you. Share this article on your social media if you find this article helpful.
How to Block an Email Address
Are you annoyed by the not so interesting and off-topic emails in your inbox? Do you want to block an email address? If you want so, then you have landed at the right place. In this article, we will tell you how to block an E-mail address? So, let’s get started:
How to block an Email address?
In this section, we will tell you how to block and email address on three major email clients that are Gmail, Yahoo! and Hotmail.
How to block an Email address on Yahoo!?
Step #1: As the very first step in the process, you will have to log in to your Yahoo E-mail account. For this, you will first have to go to the Yahoo! home page from where you will have to navigate for the login section. In the fields, you have to enter the corresponding details which include your E-mail address and the password. After that, all that you have to do is to hit enter or click on the login button. Once you have done the mentioned then you will get logged onto your Yahoo! account.
Step #2: Now, you have to navigate for the “mail” option which is usually positioned as the first option on the left-hand side of the web page. If you have found so then you have to click on it. This will open your Yahoo! mail account. If you are in the Yahoo! mail account then you are good to go to the next step.
Step #3: In this step, you will have to click on the gear-like icon which is positioned at the top right corner of the web page. This will open a contextual menu for you and from this, you will have to select the “Settings” option.
Step #4: As a result of your activity in step #3, a subsequent web page will open up as the settings section. From this “Settings” section, you have to look for “Blocked Addresses”. Once you have found so, you have to click on it. Now, you have to type the particular web address which you want to block. Remember that, you can block up to 500 email addresses on one account.
Make sure to take an appropriate backup of your mails because once you block an email address, all the e-mails will be deleted immediately and you cannot recover them back. So, better be careful. However, you can unblock the email address anytime just by highlighting it and then clicking on the remove button.
How to Block an Email Address on Gmail?
Method #1: Manually setting up filters.
Step #1: In order to block an email address on Gmail, you are required to first log in to your Gmail account. You can do so by entering the corresponding credentials of your Gmail account. Once you have logged into your account then you can proceed for the next step.
Step #2: Select the email address which you want to block. Once you have selected the email account then all that you have to do is to click on the “more” tab which is positioned at the top right corner of the web page. Now, once you have clicked on it, a drop-down menu will open for you. From this menu, you have to select “Filter messages like this”. This will open a pop up window for you. From this, you have click on the “Create filter with this search”.
Step #3: The previous step will open a subsequent window for you. From this, you have to select the appropriate option. The most recommended option is to select “Delete it”. After this, you have to select “Create Filter”. This will create the corresponding filter for you and will perform the desired action which you have selected.
Method #2: Using Extensions.
You can consider using a Google Chrome extension which is exactly designed for doing the needful for you. Though there are many extensions we recommend you to use “Block Sender for Gmail” chrome extension. After installing this extension, you will see a new option in your Gmail account as a “Block” option.
Now, all that you have to do is to select the E-mail address and then click on the block button. This will block the email account from sending you emails.
How to block an email address on Hotmail?
Step #1: As the first step, you have to log in to your Hotmail account. For this, you have to go to www.hotmail.com and then sign in to your Hotmail account by entering the corresponding credentials. Before going to the next step, you are required to have your Hotmail dashboard on your screen.
Step #2: In this step, you have to click on the gear-like icon which is positioned adjacent to your profile name at the top right corner. This will open a menu for you from which you have to select “More mail settings”.
Step #3: Now, in the subsequent window which opens up as a result of the previous step, you are required to navigate for the “Safe and Blocked Senders” option. Once you have found so, you need to select “Safe and Blocked Users”.
Step #4: On the next web page, you are required to click on the “Blocked senders” link. Now, on the new web page, you have to enter the e-mail or domain which you want to block. Once you are done, then you have to click on the “Add to list” button. This way you can easily block an e-mail address on Hotmail.
Let’s Wrap it Up.
This let’s wrap it up section brings us to the end of this article on “How to block an Email address?” We hope that this article has helped you in your quest about blocking an address on Gmail, Yahoo, and Hotmail. If it has helped you in any way then do spread the words by giving it social flares and sharing it among your peers.
Moreover, if you are left with any kind of feedback or query, then do let us know by dropping a line in the comments section right below. We would love to hear from you.
Thank you for passing by and giving it a read.
How to Add Money to PayPal
PayPal is one of the easiest ways to give payments as well as to receive payments. It is used all over the world because it is so convenient to use and it makes our transactions so simple as well as extremely safe. PayPal is one of the biggest companies that deal with online payment. If you don’t have a PayPal account yet, here is how to setup PayPal Account.
It is the best option for online shopping as well as for making payments online! It makes are transactions so much safer! By using the following methods and steps, you will be able to understand how to add money to PayPal.
#1 How to Add Money to PayPal -Through Your Bank Account
Step 1. The very first thing you need to do is to link your bank account with PayPal.
Step 2. Log in to the PayPal account of yours and you will see that near the top of the page there is an icon. That icon kind of looks likes a wallet.
Step 3. Click on the icon.
Step 4. Click on ‘Link a Payment Method’.
Step 5. After this, click on ‘Link Bank Account’.
Step 6. Now you need to select your account type and enter the routing and account numbers and click on the ‘Continue’ button.
Step 7. Click on ‘Add Bank Account’.
Step 8. Confirm the bank account. There are 2 ways to confirm it:
#1 The quickest way is through ‘Online Banking’. Just click on the wallet again and hit ‘Confirm’ next to your added account and your account is confirmed in just some minutes.
#2 The other way that might take some days is that PayPal will transfer little amounts of money to your bank account so that it can confirm that your account is a valid account. This process is only needed if you do not have an online banking account.
Step 9. It is really essential that you have entered your bank account number properly so, please recheck before adding your bank account.
Step 10. Now that your account has been linked, you can transfer money from a bank account to PayPal. Log into PayPal, under your PayPal balance, there is an icon of ‘Add Money’. Click on this icon. Now, select the bank account from which the money is to be transferred, enter the amount to be transferred and click on ‘Add’.
Step 11. Transactions may take the time of some days to complete depending on your bank and your PayPal use. Click on the ‘Activity’ button on the top of the page after you log in to check if the transaction is done or it is not, and if your transaction is not made then click on ‘transaction is processing’ to be able to see the expected clearing date.
#2 How to Add Money to PayPal by Using PayPal Cash
Step 1. For this, log into PayPal.
Step 2. You have the option to select a retailer whom you can refer to when using PayPal cash. On the website, there will be a list of retailers, and you can choose the one which is closest to where you reside or in whichever area you prefer.
Once you select the retailer, you will receive an email with a barcode. You can print this or just use it by showing your smartphone.
Step 3. Now you just have to take this code and go to that retailer that you chose. Take the amount of cash that you want to deposit in your PayPal account and the retailer will transfer this money.
However, there is a service charge of $3.95 which you need to pay in order to be able to use PayPal cash. This process does not require processing time, and your money will be instantly transferred to your PayPal account.
#3 How to Add Money to PayPal by Transferring Money Between PayPal Accounts
Step 1. To pay for certain things and services you might have to use PayPal so by this method you will be able to transfer money through PayPal to other people. People prefer this method to pay for some services as PayPal makes payments extremely safe.
Step 2. Here as well you need to have your bank account linked and verified. The steps mentioned in method #1 can be referred to link the account.
Step 3. Now log in to your PayPal account. Click on the ‘Send Money’ tab and enter the exact amount of money that you want to transfer. Enter the email address associated with that person’s PayPal account to whom you want to send the money. You work here is done. Now the money will be transferred in a few days.
Step 4. You can even request money through PayPal from other accounts if someone has not paid you on time you can just send a request. For this just log in to your PayPal account and click on the ‘Request Money’ tab and then enter the person to whom you want to send this request to, this person’s email address as well as the amount of money that you want to request for, from that person.
Step 5. Now this recipient will receive an email which says that you request money from them and to make things easier for them, there are even instructions on how to use PayPal.
You even need to understand how to receive money from PayPal if someone sends you money
When someone sends you money, you will receive an email. Now you can log in and see the money and decide the further steps. You can use it in both ways, transfer the money In a checking account or you can just use the received money through PayPal.
Whatever you prefer.
To Use PayPal, you can even link your credit cards and debit cards! You can link these two and the best part about using PayPal is that it makes all your transactions really safe as the places where you are using your credit or debit cards just receive your PayPal account number, and they will have no access to any information of your bank or your credit and debit card.
So this concludes our post of adding money to your PayPal account various methods. Here, we have covered the three easiest and convenient ways with which you can transfer money to your PayPal account, anytime.
How to Watch TV Online?
Don’t tell me that you hate watching TV!
Nine out of ten people love to watch TV shows. But what if you are limited in an environment where you can’t get a TV? Can you miss your favorite TV shows?
But from this moment you are not going to miss any TV show because I am here with a guide to show you how to watch TV online.
I know it’s better said than done. A lot of TV channels are there in every country and even in every locality. So, incorporating all the channels in one platform is a tedious task and almost impossible. Also, take a look at the blog post explaining to you how to get Netflix on TV.
How to Watch TV Online
Instead of introducing a single system that allows you to watch TV shows online for free, I will be sharing a set of websites. You can watch shows online free through each of them.
If you find any issue on one website, move on to the next one to watch TV online free.
HotStar is relatively new to this TV streaming field. But the hands behind this website are not new to the TV domain. Do you know the Star network? The same company owns HotStar as well.
Along with TV shows and movies, this service allows you to watch sports live as well. The best thing I like about this one is you don’t have to be a registered user to immerse yourself in the magical world of TV shows and movies.
On top, you will see a perfectly crafted navigation bar that includes links to different genres, movies, TV shows, sports and languages along with a search field, which will ease your quest to find favorite movies.
Most of the time, you will get what you want from the featured content on the homepage itself. If you just scroll down, you can see some other popular shows and movies too.
The next pick in our article on how to watch live TV online is BoxTV, which was making waves until the launch of Hotstar. Though the grace has faded a bit, BoxTV offers a similar kind of free TV streaming experience as in HotStar.
The top-most navigation is spared for the small but beautiful header logo, links to TV and Movies along with an intelligent search using which you can search for movies, genres and actors as well.
The slider here grabs the attention of a lot of eyeballs because all the posters are designed in a spellbinding manner.
You will get TV shows and movies in all the Indian languages and English also. So, this deserves a spot in your bookmark bar.
A paid subscription option is available for those who want to take watching free TV shows online to another level.
The language selection can be done from the secondary blue navigation bar placed just beneath the slider.
Are you looking for a way to get all the English series episodes in one place? Then, Crackle is the best website for you as it contains English serials only. If you like to peek at the site’s matrices, you will find that this one has got a high PR and good ranking. So no way for it to be a scam.
The first thing you notice on this website is the design itself. Their team has done an exceptional job of creating a minimalistic yet beautiful and functional design.
On the homepage, you can see a featured slider that contains links to different episodes of an exclusive Crackle show. The content below is also occupied by the same show episodes.
Unlike most of the other TV streaming websites, this one has an FAQ link on the navigation bar that kicks all your doubts off your mind.
Even though you can get some added benefits by signing up, you can stream shows without being a registered member.
Use the search form given above to find your favorite shows like a breeze.
TVPlayer is another best online live TV streaming website to entertain you. Seeing their homepage is a sheer pleasure as it is built in a breathtaking manner.
On the homepage, you can see a top navigation bar with links to the TV guides, channels, apps, etc. If you are not ready to waste time on anything, click on that big blue watch now button. You will be directed to a TV-like interface then.
The very first thing their system does is checking your location because they only allow live streaming for UK people only. If you are desperate to see their content and you are not living in the UK, you can make use of proxies or similar stuff for it.
The top navigation bar has a Plus link that enables you to purchase their premium version for more features.
You have to be disappointed here if you are not a UK native because this one is not available for everyone in the world.
The top navigation bar contains three beautifully crafted dropdown menus that let you browse through TV, movies, genres, latest and best selling as well.
A search form is also given to help you make the quest for a singular movie easier.
The homepage has a number of featured shows that are popular on BlinkBox. As I already said, this service is available for UK people only even if anyone can visit the website.
You need to login to watch free movies online. If you are a UK native and ready to give your email for the best TV streaming service, you are good to go.
You can also stream the best entertainment using Apple TV. Using Apple TV, you can easily stream services like Netflix, Hulu, HBO Now which provides you with high-quality entertainment in your living rooms. Here is how to setup Apple TV.
I hope you now know how to watch TV online. Tons of websites are there that claim to provide the best TV viewing experience ever. But about 75% of them are scam and loaded with unwanted ads. Good entertainment services ask for the paid subscription and you can enjoy those services on any streaming devices like Chromecast. Here is how to setup Chromecast.
But you will find that all the websites shared here show justice to the visitors with best- in- class content and smooth user experience.
You can let us know your suggestion using the comment form down below in case you want any other site to be included in this list.
Don’t forget to spare a second to share this post.
How to Upload Multiple Photos to Instagram at Once?
How to upload multiple photos to Instagram one of the unsolved queries of Instagram users which makes them wander here and there for the Answer.
Instagram doesn’t offer any official solution for uploading multiple photos at a time. If we try to do so, all the photos will be uploaded one by one making our followers annoyed!
And some pictures indeed look in greater when they are uploaded in a group. Unlike Facebook, Instagram doesn’t support photo albums, so there are no chances of uploading them together.
The simple workaround for this problem is to group all these photos together and then upload them as a collage. Great solution, isn’t it?? It indeed is, but the problem persists.
Although, now we know the solution to our problem is to group the pictures into one but how to do more than one photo on Instagram is still a question. Let’s find out the answer.
How to Upload Multiple Photos to Instagram:
Instagram, however, doesn’t offer the inbuilt feature of combining multiple pictures into one but probably the Instagram team was aware of this desire of their users. This might be the reason that Instagram took a bold step and introduced a completely separate app for collaging multiple images into one. The app we know as Layout from Instagram.
This app is available for IOS and Android. This is not the only app available for grouping Instagram pictures into one. In fact, some apps like InstapicFrame, Photo shake, Diptic, and many other apps are available out there which functions almost the same as Layout from Instagram.
It’s not possible for us to cover all these apps in-depth in this very article but we will indeed give you an idea of how these apps work by giving you the step by step instructions of working of Layout from Instagram and InstapicFrame.
#How to Upload Multiple Pictures at Once Using Layout from Instagram:
In order to use Layout from the Instagram app, you first have downloaded this app from the Google play store! It’s a free app, simple and very easy to use the app. To install this app on your Android, Go to play store, search for Layout from Instagram. Click on the first link and install this app.
Or simply click here and install this app. Once you have this app on your phone, just open this app. Have a look at the below screenshot to see the first screen you will see while opening the app.
At the bottom of the screen, you can see the options. The first option is the Gallery, which carries every photo on your phone. The second option is Faces, which contains all the photos with people’s faces on your phone and last but not least, the third option is Recent. The recent tab contains up to 30 recent used photos on your phone.
Tap any of the options as per your priority and choose up to 9 photos you want to merge in your collage. To select the photos, a long tap on the images. The selected images will have a tick on it.
Once the images are selected, you need to select the desired frame. Click on the Choose Layout option at the top of the screen. See the above screenshot.
Once you’ve selected any suitable layout for your images, it’s time to edit the images with the right effect and make them look beautiful. It’s the best time to show your creativity and to make the collage look beautiful. See the below screenshot to understanding this step better.
To edit any image in the layout, just tap that image and put the appropriate effect. You can use the pinch in or pinch out to set the image correctly. Or if you want to replace the image or frame, you can do that as well. For this, tap the REPLACE option at the bottom.
Moreover, you can also add the mirror effect in the layout or Flip the images by taping over the MIRROR and FLIP option at the bottom respectively. Once you are done with all the settings, save your collage and upload it on Instagram, or you can share them on any social medium if you want.
Another best feature of Layout from Instagram is Photo Booth. Photo booth captures your pictures simultaneously with the front camera on your phone and lets you create a collage out of these recently taken pictures.
To use the Photo Booth, tap the Photo Booth icon. You will see the icon on the screen. Once you tap on this icon, the Photo Booth will take up to four photos of your continuously. Now you can select the desired frame for your photos, edit the images and can save to upload on Instagram. You can see the below screenshot to see where you will find the Photobooth option.
#How to post multiple photos on Instagram With InstapicFrame:
Working on InstapicFrame is extremely seamless and hassle-free. Here are the quick steps on how to use InstapicFrame to group multiple images into one.
Go to google play store and install the InstapicFram app on your device. Once the app is installed on your device, open it up. In the Layout for the Instagram app, you selected the photos first and then you selected the layout of the frame. But in the InstapicFrame, you need to select the template first and then you need to select the photos.
So when you open the app, you will see the following screen.
Once the appropriate frame is selected, tap the empty area on the frame and browse the image you want to upload. You can also click your current image if you want. Once the image is selected, you need to select other images as well by clicking on the other free image slots.
Once the images are uploaded, tap Done. You can also edit the images if you want. Once all the changes are done, save the image on your mobile. You can also directly share the image.
By getting to know the working of above two apps, you might assume How to Upload Multiple Photos to Instagram using the other apps too! There features as well as their working is almost same.
It’s time for us to wrap up the article now! I hope the article was helpful to you! For any doubts or query, just drop us a comment!
How to Subtract in Excel?
Subtracting a value is one of the most basic things you learn in elementary school. And learning Excel is undoubtedly like the new ‘elementary school’ for office workers.
It’s safe to say that Microsoft’s Excel is one of the most used software across the world for collecting and saving various types of data.
So if you know the basics of using Excel, then you can easily get the required job done in half the time and quarter the efforts. That’s why today we have brought you a guide about subtracting a value in EXCEL.
Uses of Subtracting in Excel.
Before learning how to subtract in excel, let’s have a look at tasks we can perform once we have learned it.
First of all, of course, Subtracting in Excel will help you to do calculations faster. You won’t need a calculator opened side by side and switch between tabs, instead, you can just enter the values in an Excel Cell and get the job done.
But that’s not all; the subtraction option is also used for getting more complex inputs like if you have a list of employees, then you can easily get data like how many employees are reaching the retirement age by subtracting the number of total employees with the number of employees under 55.
This can save you lots of time and work and can help you in getting important data in real-time. That’s why people believe that even the simplest Excel formulas are the lifeline for your business.
How to Subtract in Excel?
By default, there is no function to subtract values in Excel. We use the SUM function to subtract any value. There is a total of two ways to do so. One is by directly entering the values in numbers or by referencing to cells containing numbers.
Both are more suitable for different situations, and we have made a detailed guide on both below-
Method 1: How to Subtract on Excel by Direct Entering the Values?
Sometimes all you need to do is a simple subtraction and it’s really a pain in the neck if you open a calculator for every subtraction. But if you know how to do it in the excel sheet itself then the job becomes easier. The follow the below steps to do so:
Step #1: Type the equal (=) sign in the cell you want the subtraction result to appear. Always remember that any formula in Excel begins with an equal sign.
Step #2: Type the first number of the equation. For example, let’s say we typed 11.
Step #3: Put the dash (-) sign after the first number. It’s the sign for minus in Excel.
Step #4: Type the 2nd number. For example, if the 2nd number is 4 then after entering it the formula will look like this = 11 – 4
Step #5: Now hit the enter button and the computer will automatically show the result of the equation. In the above example, it will show the number 7 as 11-4 will be 7.
Method 2: Using Subtraction Formula in Excel
The above method is good for quick calculations. In this, we will make use of an excel formula for subtraction. But what if you need to record lots of data and subtract them all?
In this condition using excel, excel subtraction formula is the best method. For example, if you enter the data of Apples and oranges you sold each day in the month.
And then you subtract the number of apples from oranges to know the difference between the two. But after a month, you get to know that you were entering the number of apples wrongly, and now you’ll have to re-enter the numbers.
Now if you have used the above method and calculated the difference by directly entering the values, then you’ll have to recalculate each one of them too.
But if you have used the excel subtraction formula, then you can just change the values in the range cells and the calculated data will be updated automatically. Here is how to use the subtract formula in excel-
Step #1: First, write the values you want to use in the formula, for example, we are going to subtract 128 from 345. So first enter 345 in the third line of B Range and 128 in the 2nd line of B range.
Step #2: Now enter the equal sign (=) in the cell you want the results to appear in(B4 in this example). Always remember that the formulas in Excel are started with an equal sign.
Step #3: Now enter the first cell reference after the equal sign. In this example enter the value B3.
Step #4: After that, add the dash sign (-) which is the sign of minus in Excel.
Step #5: Now enter the second value after the dash sign. In the current example, we will enter the value B2. After it, the equation will look something like this-
= B3 – B2
Step #6: Now press the enter button and the result of the equation will show in the cell. in the current example it will be 345 (B3) – 128 (B2) = 217.
Now if you ever need to change any value of the equation, you can just change the value in the related range cell, and the equation will be updated accordingly.
Method 3: Subtraction in Excel using Formula with Direct Values
So till now, you have learned how to subtract in Excel by entering direct values and subtraction in Excel using a formula. But there is another way you can use the Subtract function in Excel.
It’s not really a different method than the last two, rather than its a combination of both. It’s used when one of the values has to remain the same.
For example, if you have 100 candidates, and you know that every one of them is at least 160 cm long. But now you have to know the difference between each one of their heights and the standard height (160 cm in this example.).
Now if you put the number in a cell and then use its cell reference in the formula then, it will be easy, but a whole range cell where just one cell is in use will not only look ugly but also it will confuse others if the same data is used by multiple people.
So in this condition, we will use the following technique to subtract in excel-
Step #1: Enter all the data in a range cell in different cells. For example, if you need to enter the info about the heights of all candidates then we’ll enter them one by one. Let’s say that heights of 5 different people are 175, 165, 167, 180 and 178. Now we enter these numbers in the 1, 2, 3, 4 and 5 lines of B range.
Step #2: Now go to the range where you want the results to appear and put an equal sign (=) in the start.
Step #3: Now enter the cell references in different cells where you want the result to appear. In this example, we enter the cell references B1, B2, B3, B4, and B5.
Step #4: Now enter the dash sign (-) after every cell reference. It’s the minus sign of Excel.
Step #5: Now enter the value you want to subtract. For this example, we have chosen the value 160 so after entering it the example formula will look like this = B1 – 160
Now when you hit enter the results of the formula will show. In this example the result will be 175 (B1) – 160 = 15.
So these were the three ways you can use to subtract in excel. Which Excel tutorial would you like us to write next? Do tell us in the comments section.
Do we hope that we were efficient enough to help you in your quest of how to subtract on excel?
Thank you for crossing by and stay tuned.
Tech3 weeks ago
How to Solve Yahoo Mail not Working?
Computers4 days ago
How to Reset Macbook Air?
Mac2 weeks ago
How to Use Apple Thunderbolt Display with PC?
Tech3 weeks ago
How to Make a Yahoo Account Without a Phone Number?
iOS1 day ago
How to Stream Torrents on iPhone?
Tech3 weeks ago
How to Tame a Horse in Minecraft?
Tech3 weeks ago
How to Receive Money through PayPal?
Windows5 days ago
How to check RAM type (DDR, DDR2 or DDR3) in Windows?