Scribd
Upload
79 views7 pages

BFTVC Assignment: Submiited To:-Ms. Harleen Sahni Submitted By: - Jasleen Sardar Syntax and Examples of If and Nested If

The document discusses examples of using IF and nested IF functions in Excel. It provides the names and marks of 7 students, and uses IF functions to calculate add-ons to marks based on certain criteria. It also uses SUMIF and COUNTIF functions to sum the marks and count values meeting specified conditions.

Uploaded by

Jasleen Chawla
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
79 views7 pages

BFTVC Assignment: Submiited To:-Ms. Harleen Sahni Submitted By: - Jasleen Sardar Syntax and Examples of If and Nested If

The document discusses examples of using IF and nested IF functions in Excel. It provides the names and marks of 7 students, and uses IF functions to calculate add-ons to marks based on certain criteria. It also uses SUMIF and COUNTIF functions to sum the marks and count values meeting specified conditions.

Uploaded by

Jasleen Chawla
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

BFTVC ASSIGNMENT

Submiited to :- Ms. Harleen Sahni Submitted by:- Jasleen Sardar Syntax and examples of If and Nested If
Syntax IF(logical_test,value_if_true,value_if_false) Example
Name Jasleen Upasana Palak Rutu Manali Anamika Prabhdeep Total If Marks 75 84 65 48 96 57 79 504 1

f and Nested If

Example
Name Jasleen Upasana Palak Rutu Manali Anamika himani autosum Marks add-ons 75 9 84 10.08 65 7.8 48 NO ADD-ONS 96 NO ADD-ONS 57 NO ADD-ONS 79 9.48 504

min amt max amt add-ons

65 95 12%

Example
Name Jasleen Upasana Palak Rutu Manali Anamika himani autosum min amt max amt Marks 75 84 65 48 96 57 79 504 65 95 add-ons add-ons add-ons no add-ons add-ons no add-ons add-ons

Example
Name Jasleen Upasana Palak Rutu Manali Anamika himani autosum Sum If Marks 75 84 65 48 96 57 79 504 334

Example
Name Jasleen Upasana Palak Rutu Manali Anamika himani autosum countif Marks 75 84 65 48 96 57 79 504 4

Example
Name Jasleen Upasana Palak Rutu Manali Anamika himani autosum Marks 75 84 65 48 96 57 79 504 add-ons 9.375 13.44 8.125 4.8 15.36 5.7 9.875

marks
<40 >=40and <60 >=60 and <80 >80

add-ons
7% 10% 12.50% 16%

You might also like