What is IF function in Excel? IF function - is a logical function - that checks the condition you put and returns you one value if the condition is TRUE, else the other value if the condition is FALSE So the syntax for IF function is: =IF(condition, value_if_true, value_if_false) It simply says, if ...

First let us know what is a cumulative sum? A cumulative sum is the summation of numbers in a given sequence. For example, the cumulative sum of the sequence {1,2,3,4,5....} is 1 , 3 (1+2), 6 (1+2+3), 10 (1+2+3+4), 15 (1+2+3+4+5)....... and so on. That means everytime you add a new number to your se...

In Excel You can easily combine texts from two or more cells into one cell using the ampersand (&) operator. See the following example: http://shamskm.com/forum/exceltutor/combining_texts_from_two_cells_into_one_cell_in_excel.jpg In cell C2 enter =A2 & " " & B2 For the remainin...

It's just little bit tricky to enter fractions and mixed numbers in Excel. Just that. Let's make it easy. Fractions When you enter any fraction like 5/6 or 7/8 in your cell, Excel interprets these fractions as date and automatically format the cell as a date. To enter a simple fraction: first enter ...

In Excel you can calculate 'standard deviation' and 'mean absolute deviation' of your data points or samples, so to say, with STDEVA function and AVEDEV function . But before we proceed, let's make it clear what are these two deviations. The terms make you little bit confused. So let's get it clear ...

In previous lesson we discussed about separable verbs and thier usage. Here we will talk about inseparable verbs with examples. The following prefixes form inseparable verbs - regardless of tense or form of the verbs, these prefixes are always attached with the main verbs and are never separated! be...

The following browser shortcuts will help your internet navigation easily: To open your internet bookmarks press Ctrl + B . To close the bookmarks, press again Ctrl + B To bookmark the current internet page press Ctrl+D To refresh or reload a web page press F5 or Ctrl + R To open the search option p...

Looking for a perfect antivirus for your pc or laptop. You can use 'Avast Antivirus' – a robust antivirus programme. You can use the free version. It's compatible with Windows 10, 8.1, 8, 7, Vista, XP SP3. To download it, go here: Avast Antiviris Just for caution : Before you install it to your pc, ...

In this tutorial you will get to know most useful keybord shortcuts in Excel. So here we go :-) Open a spreadsheet - Ctrl+O Close a spreadsheet - Ctrl+W Save a spreadsheet - Ctrl+S Open the Save As dialog box - F12 Select the entire worksheet - Ctrl+A Select an entire column in a worksheet - Ctrl+Sp...

Political Vocabulary in German die Politik – politics der Politiker – politician (feminine: die Politikerin) der Kanzler - Chancellor (feminine: die Kanzlerin) die Wahl – election, vote (pl. die Wahlen) der Wähler – voter (feminine: die Wählerin) der Wahltag – election day (pl. die Wahltage) die Ka...

To get the current date and time, use the NOW function. =NOW() http://shamskm.com/forum/exceltutor/now_function_in_excel_.jpg However, to get the current date only use the TODAY() function. http://shamskm.com/forum/exceltutor/today_function_in_excel.jpg To get the current time only use =NOW()-TODAY(...

It's a typical characteristic in German language: you can add prefixes to many verbs and then the verbs get new meanings. In German these verbs are called 'Trennbare Verben'. The separable verbs usually come with the following prefixes: ab-, aus-, an-, auf-, bei-, ein-, fern-, fort-, hin-, her-, los...

According to WWF (World Wildlife Fund), Bhutan is the only carbon-negative country in the world.

More than 70% of Bhutan is under forest cover.

It is also one of the happiest nations on Earth.

Source: Twitter/WWF

Researchers found that ambient temperature of the developing eggs determines gender (male or female) in alligators and in some turtles. It's also known as temperature-dependent sex determination (TSD). Eggs incubated at 33 ºC produces mostly males, while incubation at 30 ºC produces mostly females. ...

The lion's mane jellyfish is the largest known species of jellyfish on Earth. It's also known as the giant jellyfish or the hair jelly. Scientific name: Cyanea capillata But how large it is? With tentacles up to 190 feet (57.91 meters) long and a bell diameter of almost 7 feet (2.13 meters) wide, so...