cellularmop.blogg.se - Openoffice calc cell reference

#Openoffice calc cell reference how to

(Click on the handle and drag the handle to cell B5) ( E appears in A1, D appears in A2, C appears in A3, and #N/A appears in A4 & A5 )ī1 has the formula =LOOKUP(A1 E1 1:E1 5 F1 1:F1 5)ī2 has the formula =LOOKUP(A1 E1 2:E1 6 F1 2:F1 6)ī3 has the formula =LOOKUP(A1 E1 3:E1 7 F1 3:F1 7)ī4 has the formula =LOOKUP(A1 E1 4:E1 8 F1 4:F1 8)ī4 has the formula =LOOKUP(A1 E1 5:E1 9 F1 5:F1 9) Select B1 again and drag the formula to B5. There is a colon after E11 andį11) (Press Enter for the formula to be accepted)

Įnter 5 in A1, 4 in A2, 3 in A3, 2 in A4, and 1 in A5.

Įnter the letter A in F11, B in F12, C in F13, D in F14, and E in F15.

(Click on the handle at the lower, right corner of cell E11, hold the click and drag the handle down to cell E15, then release the click) (Click on cell E11, then press the 1 key (the number one key), then press Enter. There are six different look-up functions in Calc.Ī particular circumstance will determine which particular look-up(s) toįirst you will do an actual LOOKUP then there will be an explanation ofĮnter 1 in Cell E11. If not, do the tutorials in Chapter One of Calc before doing this tutorial.Ĭlick on our website The path to reach Chapter One is: Home Page > Calc One Goal – Many Ways This tutorial assumes that you already have some experience using spreadsheets. Businesses use theĭatabase-like structure of spreadsheets to produce invoices, track inventory,Įstimate costs, or manage budgets all of these tasks require some form Spreadsheets are composed of individual cells that are like separate blocks

#Openoffice calc cell reference how to

This tutorial explain how to use the Look-Up functions in Calc. Tutorial donated by Wayne Tschirhart Purpose

MATCH(search_criterion lookup_array type).V(H)LOOKUP(Search criterion array index sort order).