जब हम स्प्रेडशीट (जैसे Excel या Calc) में सूत्र (Formula) बनाते हैं, तो सिर्फ संख्याएँ (values) ही नहीं, बल्कि कोशिका पते (Cell Addresses) भी उपयोग किए जाते हैं।

1. कोशिका पते का उपयोग

• हर Cell का एक address होता है (जैसे A1, B2, C3)।

• Formula में इन पते का प्रयोग करने से परिणाम स्वचालित (automatic) रूप से बदलता है, अगर Cell का Data बदल दिया जाए।

उदाहरण:

• अगर A1 = 10 और B1 = 20 है, तो
  Formula → =A1 + B1
  Result → 30
  (अगर बाद में A1 को 15 कर दिया जाए, तो Result अपने-आप 35 हो जाएगा)

2. सामान्य ऑपरेटर

• + (Addition / जोड़ना)

• - (Subtraction / घटाना)

• * (Multiplication / गुणा)

• / (Division / भाग)

• ^ (Exponentiation / घातांक, जैसे 2^3 = 8)

3. उदाहरण

• =A2 + B2 → Addition

• =C3 - D3 → Subtraction

• =A4 * B4 → Multiplication

• =C5 / D5 → Division

• =A1 + B1 * C1 → Mixed Operators (पहले गुणा, फिर जोड़)

👉 इससे साफ है कि cell addresses और operators के साथ formula ज़्यादा smart और dynamic बन जाता है।

When you create a formula in a spreadsheet (like MS Excel or LibreOffice Calc), instead of typing actual values (numbers), you often use cell addresses.
This makes the formula dynamic – meaning if the value in the cell changes, the result of the formula also changes automatically.

1. Using Cell Addresses in Formulas

• Every cell has a unique cell address (like A1, B2, C5 etc.) which is defined by its column name + row number.

• You can write formulas using these addresses instead of fixed numbers.

Example:

• If A1 = 10 and B1 = 20, then:
  Formula → =A1 + B1
  Result → 30

Now, if you change A1 to 15, the result will automatically update to 35.

2. Common Operators Used

You can combine cell addresses with operators:

• Addition (+) → =A1 + B1

• Subtraction (-) → =A1 - B1

• Multiplication (*) → =A1 * B1

• Division (/) → =A1 / B1

• Exponentiation (^) → =A1 ^ B1 (e.g., 2^3 = 8)

3. Example Formulas

1. Addition: =A2 + B2

2. Subtraction: =C3 - D3

3. Multiplication: =A4 * B4

4. Division: =C5 / D5

5. Mixing Operators: =A1 + B1 * C1
   (Here, operator precedence applies → multiplication happens first)

4. Advantages of Using Cell Addresses

✅ Dynamic results (no need to rewrite formula when values change)
✅ Easy to copy formulas to other cells (auto-adjusts to new cell addresses → relative referencing)
✅ Makes spreadsheets flexible and powerful