Scribd
Upload
7 views1 page

Excel Formulas for Conditional Calculations

The document provides various Excel formulas for calculating percentages, conditional logic, and counting occurrences. It includes examples of basic IF statements, nested IFs, AND/OR conditions, and the COUNTIF function. Each formula is presented with its syntax for easy reference.

Uploaded by

captainjarvis00
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

Excel Formulas for Conditional Calculations

The document provides various Excel formulas for calculating percentages, conditional logic, and counting occurrences. It includes examples of basic IF statements, nested IFs, AND/OR conditions, and the COUNTIF function. Each formula is presented with its syntax for easy reference.

Uploaded by

captainjarvis00
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1.

FOR PERCENTAGE
=OBTAINED MARKS/TOTAL MARKS*100
2. IF FORMULA
=IF(LOGIC/CONDITION,”TRUE RESULT”,”FALSE RESULT”)
3. IF AND FORMULA MORE THAN ONE CONDITION AND ALL CONDITION TRUE
=IF(AND(CONDITION1,CONDITION2,CONDITION3……),”TRUE VALUE”,”FALSE
VALUE”)
4. IF OR FORMULA MORE THAN ONE CONDITION BUT IF ONE CONDITION WILL BE
TRUE RESULT SHOULD BE TRUE
=IF(OR(CONDITION1,CONDITION2,CONDITION3),”VALUE TRUE”,”VALUE FALSE”)
5. NESTED IF ---IF KE ANDAR IF
=IF(CONDITION,”TRUE VALUE”,IF(CONDITION2,”TRUE VALUE”,IF(CONDITION3,”TRUE
VALUE”,”FALSE VALUE”)))
6. COUNTIF
=COUNTIF(RANGE,CONDITION)

You might also like