Ulet उपयोगकर्ता गाइड

Windows के लिए Ulet का इस्तेमाल शुरू करें।

Use Cell References in Spreadsheet Formulas on Windows

A cell reference combines a column letter with a row number. B2 means column B, row 2. References let a formula use values already stored in the worksheet.

For matching example data, use the Practice workbook section at the end of this guide.

Build a formula from two cells

  1. Open a fresh working copy of the Riverside expense workbook.

  2. On Expenses, check B2 and B3: Paper is 12 and Pens is 8.

  3. Enter Paper and pens in F1 to label a small practice calculation.

  4. Select F2, enter =B2+B3, and press Enter.

  5. Select F2 again and compare the formula bar with the result, 20.

English expense worksheet with a Paper and pens calculation using B2 plus B3 and displaying 20

View screenshot at full size

The formula names the two input cells, and the grid shows their combined amount.

Read the reference

The equals sign begins the formula. The plus sign adds the values currently held in B2 and B3. Those addresses are different from the destination F2, where the result appears.

Check the column and row labels before editing an input or formula. A nearby cell can contain a category or an owner name rather than the amount you intended to use.

Save and inspect

Press Ctrl+S. After reopening the workbook, select F2 to confirm that its stored contents are still =B2+B3 and that the expected inputs remain in their original cells.

Practice workbook

To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.

Item

Amount

Category

Owner

Status

Paper

12

Supplies

Alex

Complete

Pens

8

Supplies

Sam

Complete

Desk lamp

45

Equipment

Jordan

Planned

Notebook

15

Supplies

Alex

Planned

Storage box

20

Equipment

Sam

In progress

Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.

Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

Ulet

रोज़मर्रा के काम के लिए आपका संपूर्ण ऑफ़िस सूट।

सुविधाएँ देखें