One formula a day
Daily Excel Challenge
A small sheet, one question, one formula. Any formula that gives the right answer counts. Come back tomorrow for the next one.
Today's challenge · 17 OctoberEasy
New today
Pass or fail
For Kunal (row 3), show "Pass" if Marks are 35 or more, otherwise "Fail".
| A | B | C | |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Tap a cell to put its name in your formula.
What the challenges teach
32 challenges rotate through the functions and ideas every office uses:
- SUM
- AVERAGE
- MAX
- COUNTIF
- SUMIF
- COUNTIF with >
- IF
- COUNTIF with >=
- ROUND
- LARGE
- RANK
- Multiplication
- SUMPRODUCT
- VLOOKUP
- INDEX and MATCH
- COUNTA
- Division
- Percentage
- INDEX and MATCH with MIN
- COUNTIF with COUNTA
- IF with COUNTIF
- & (join text)
- PROPER
- LEFT with FIND
- LEN
- Percentage change
- SUM in a comparison
- IF with comparison
- AVERAGEIF
- SUMPRODUCT with a comparison
Want the whole toolbox?
Advanced Excel (1 Month, ₹8,000) takes you from SUM to pivot tables, dashboards and automation, hands-on.
See the Excel courseGood to know
Excel Challenge Questions
How does the daily Excel challenge work?
Every day there is a small sheet and one question. Type a formula like you would in Excel (starting with =) and check it. Any formula that gives the right answer counts, hints are there if you are stuck, and there is a fresh challenge every day. Nothing is saved: the website keeps no record of your answers.
What is the difference between COUNT and COUNTA?
COUNT counts cells that hold numbers. COUNTA counts every cell that is not empty, text included. COUNTBLANK counts the empty ones.
What does VLOOKUP do?
VLOOKUP looks for a value in the first column of a table and returns a value from the same row in another column: VLOOKUP(what to find, table, column number, FALSE). FALSE asks for an exact match; without it Excel assumes the first column is sorted and may return the wrong row.
Why does Excel say #NAME?, #VALUE! or #DIV/0!?
#NAME? means a function or range is misspelt. #VALUE! means a value has the wrong type, usually text where a number is needed. #DIV/0! means the formula divides by zero or an empty cell. #N/A means a lookup did not find its value.