HP NW280AAABA Manual de usuario descargar pdf (Pagina 200)

100

101

196 Spreadsheet

3. Enter PRICE and tap . You have named the entire

first column PRICE.

4. Select column B. Either tap on B or use the cursor keys to

highlight the B cell.

5. Enter a formula for your commission (being 10% of the

price of each item sold):

S.PRICEs0.1E

Because you entered the

formula in the heading of

a column, it is

automatically copied to

every cell in that column.

At the moment only 0 is

shown, since there are no

values in the PRICE

column yet.

6. Once again select the header of column B.

7. Tap and select Name.

8. Type COMMIS and tap .

Note that the heading of column B is now COMMIS.

9. It is always a good idea to check your formulas by entering

some dummy values and noting if the result is as expected.

Select cell A1 and make sure that and not is

showing in the menu. (If not, tap the button.) This option means

that your cursor automatically selects the cell immediately

below the one you have just entered content into.

10.Add some values in the

PRICE column and note

the result in the COMMIS

column. If the results do

not look right, you can tap

the COMMIS heading, tap

and fix the

formula.

1 2 ... 195 196 197 198 199 200 201 202 203 204 205 ... 615 616

Comentarios a estos manuales

Sin comentarios

HP NW280AAABA Manual de usuario Pagina 200

Comentarios a estos manuales

Relacionado con productos y manuales para Software HP NW280AAABA