This post is a continuation of one of my previous posts Lesson#27: How to make a calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
Lesson#31: Current dynamic calendar for whole Year Read more »
In this post, we will learn to make a calendar which will take input of month from 1 (JAN) to 12 (DEC) and year in numeric format and show the whole month calendar. 1st Step: Make a 2×2 table like …
Lesson#27: How to make a calendar in excel without VBA Read more »
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in a year. Syntax of this function is WEEKNUM(serial_number,[return_type]) where serial_number is a date and [return_type] is optional. A number that determines on which day the …
Lesson#25: Function WEEKNUM has a good use for construction people Read more »
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more »
In this lesson, we will learn a method to convert digits into words. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, and MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant …
Lesson#19: How to convert digit into word in excel Read more »
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. COUNT is a function that counts the number of cells in a range that contains a number. I have given an example of COUNT …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more »
In this post we will discuss nested IF making. I have to show Grade on the mark sheet so I will check multiple conditions by IF. The structure of nested IF will be like this =IF(E5<85,IF(E5<70,IF(E5<55,IF(E5<40, IF(E5<25, “F”, “E”), “D”), “C”), …
In this post, we will discuss function IF. IF is a logical function that checks whether a condition is met and then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, …