Formulas in Kazi Sheets
Write formulas in Kazi Sheets: operators, cell references, ranges, absolute references, function suggestions, error values and practical examples.
A formula starts with = and calculates a value. Kazi recalculates every formula as soon as anything it depends on changes.
Your first formula
- Type numbers into
A1,A2andA3. - In
A4type=SUM(A1:A3)and press Enter. - Change any number:
A4updates immediately.
As you type a function name, Kazi suggests matching functions with their syntax.
Operators
| Operator | Meaning | Example | Result |
|---|---|---|---|
+ - * / | Add, subtract, multiply, divide | =10*3-4/2 | 28 |
^ | Power | =2^3 | 8 |
% | Percent | =200*10% | 20 |
& | Join text | ="Hello "&"World" | Hello World |
= <> > < >= <= | Compare | =A1>100 | TRUE or FALSE |
Kazi follows standard spreadsheet precedence: ^ first, then * and /, then + and -. Use brackets to be explicit: =(A1+A2)*B1.
References
| Reference | Means |
|---|---|
B3 | The cell in column B, row 3 |
B2:B9 | A range from B2 to B9 |
A1:C3 | A block of 3×3 cells |
$B$1 | An absolute reference: it doesn't change when the formula is copied |
B$1, $B1 | Mixed: only the row (or column) stays fixed |
When you copy a formula to another cell, relative references shift with it. =A1*2 in B1 becomes =A2*2 in B2. Use $ for values that must stay put, like a tax rate in $F$1.
Everyday examples
| Task | Formula |
|---|---|
| Total a column | =SUM(B2:B50) |
| Average | =AVERAGE(B2:B50) |
| Count filled cells | =COUNTA(A2:A50) |
| Line total | =B2*C2 |
| Add 18% VAT | =B2*1.18 |
| Pass or fail | =IF(C2>=50,"Pass","Fail") |
| Look up a price | =VLOOKUP(E2,A2:C100,3,FALSE) |
| Monthly loan payment | =PMT(12%/12,24,-1000000) |
| Days between dates | =DAYS(B2,A2) |
| Round to 2 decimals | =ROUND(B2,2) |
Browse all 119 functions in the function reference.
Error values
| Error | What it means | Typical fix |
|---|---|---|
#DIV/0! | Division by zero | Check the divisor, or wrap in IFERROR |
#VALUE! | Wrong type of value (for example text in maths) | Make sure the cells hold numbers |
#NAME? | Unknown function name | Check the spelling |
#REF! | The formula points to a cell that doesn't exist | Fix the reference |
#N/A | A lookup found nothing | Check the lookup value, or use IFERROR |
#NUM! | The number is invalid for the function | Check the inputs (for example a negative square root) |
#CIRC! | The formula depends on itself (circular reference) | Break the loop |
#ERROR! | The formula can't be read | Check brackets and commas |
Tip:
=IFERROR(VLOOKUP(E2,A:C,3,FALSE),"Not found")shows a friendly message instead of#N/A.