#if function

Learn how to use the IF function in Excel to automate score calculations in a scorecard. Boost your productivity today! #Excel #IFFunction #Productivity

Today, I will show you how to make a scorecard in Excel and use the IF Function to calculate the scores automatically. We have a list of students who have all completed our test. If the student has scored more than 80 points, we should fill the results column with “Pass”; if they score less than 80 points, we should fill it in with “Fail”. What is the IF Function The IF function checks if a…

Excel IF Function | Advanced Excel Course Online

প্রফেশনাল লাইফে মাইক্রোসফট এক্সেলের ব্যবহার করতে হয় প্রায়শই। বেসিক যোগ বিয়োগ গুণ ভাগ এর কাজ গুলোর বাইরেও এক্সেলের মাধ্যমে অনেক বড় ডাটা শীট ম্যানেজ করা, সমস্যা সমাধান করা সম্ভব হয়। যেমন মনে করেন একটা কারখানার প্রোডাকশনের হিসাব নিকাশ যদি এক্সেলের মাধ্যমে রাখতে যাওয়া হয় তবে সেখানে অনেকগুলো লজিকের সমন্বয়ে সেই ডাটা শীটটি প্রস্তুত করতে হবে।

How to Make a Student Marksheet in Microsoft Excel

Microsoft Excel is awesome tool for calculation and analytic reporting. You can easily get such task done with ultimate accuracy. Today in this article we will try to cover some basic and advance functions of Microsoft Excel to calculate Students’ marks, their percentage, grades, ranks and result.

Lets prepare a table in Microsoft Excel as Image 1.

Image 1

In this Article we will explore…

Post has been published on http://www.varindersandhu.in/2012/07/25/excel-compare-data-of-two-different-columns-if-function/

Excel – Compare data of two different columns - IF Function

Sometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function.

Syntax:

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

IF (logical_condition, value_if_true, value_if_false)

Example:

Say we have two columns as

Excel – Compare data of two different columns

Now we can use the IF function as IF (A1=B1, TRUE, FALSE)

Excel – Compare data of two different columns

According to our IF condition if the data value of column A and column B are equal/matched then “True” value will be displayed in the  Column C otherwise “False” will be displayed.