Building criteria with comparison operators, concatenating cell references with ampersand (&), and partial text matching using wildcards.
This lesson is a free preview. No account is needed to read it.
The video for this lesson has not been published yet. The written lesson below is the full material for this session.
Conditional functions Excel ki sabse powerful reporting engine hain jo specific business rules ke according data calculate karti hain.
| Operator | Meaning | Static Formula Example | Dynamic Cell Ref Example |
|---|---|---|---|
= | Equal to | "Sales" | E2 |
> | Greater than | ">50000" | ">" & E2 |
>= | Greater than or equal to | ">=25000" | ">=" & E2 |
< | Less than | "<10000" | "<" & E2 |
<= | Less than or equal to | "<=5000" | "<=" & E2 |
<> | Not equal to (Exclude) | "<>Cancelled" | "&<>" & E2 |
[!IMPORTANT] Jab aap kisi cell reference (jaise
E2) ko comparison operator ke saath use karte hain, to operator ko quotes mein aur cell ko&se jodein:=COUNTIF(C2:C100, ">=" & E2)
* (Asterisk): Zero ya multiple unknown characters ko match karta hai:
"A*" → Har wo text jo A se shuru ho (Amit, Anil, Apple)."*Excel*" → Text jisme kahin bhi Excel word ho.? (Question Mark): Exactly 1 single character ko match karta hai:
"A?it" → Amit, Ajit match karega, lekin Abhijit nahi.~ (Tilde): Actual * ya ? symbol ko literal character ke roop mein search karne ke liye escape char hai ("~*").A se start hone wale items count karein =COUNTIF(A2:A100, "A*").25000 likhein aur formula =COUNTIF(Sales, ">=" & E2) test karein.Practice live Excel formulas directly in your browser. Real calculation verified by HyperFormula.
Calculate total revenue in cell D6 by summing all items in column D (cells D2 to D5).
Every formula you enter is evaluated by a real spreadsheet engine in your browser — results are not pre-computed.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit Price | Total |
| 2 | Laptop | 5 | 45000 | 225000 |
| 3 | Mouse | 20 | 500 | 10000 |
| 4 | Keyboard | 15 | 1200 | 18000 |
| 5 | Monitor | 8 | 12500 | 100000 |
| 6 | Grand Total |
5 practical questions testing single and multi-condition criteria analysis in Excel.
This quiz has 5 questions. Sign in to answer them — results are saved to your account.
Sign in to attemptSign in to submit your work for this assignment.
Stuck on a formula or edge case? Ask questions, upvote solutions, and earn community XP.
No questions yet on this lesson
Be the first to ask a doubt or start a discussion with peers and mentors!
Module 8: Mathematical & Statistical Functions
Module 9: Conditional Functions & Criteria-Based Analysis