This isn't as flashy, but ISBLANK( cellreference) or ISBLANK( cellrange) can be used for error checking or just seeing if you've got blanks where you shouldn't. The second set is divided by the first set The second set of numbers, that you paste onto, are divided by the ones you copied. Here's what before and after for division look like. The cells you copied are added to the cells you pasted. In the window that appears, choose All in the left column, then under Operations choose Add. Select the other set of cells and choose Paste Special.

You can add, subtract, multiply, or divide values of one set of cells with another. Paste Special, using the Operations section. To copy and paste only cells that contain formulas, copy, then choose Edit > Paste Special. To display formulas by other means, choose Tools > Options > Calc > View, and under the Display area, choose Formulas. =FORMULA(B6) shows you the formula from B6. First of all: if you want some great tips on using formulas, go to or (same site).īut here are some that I think are useful: formulas, related items, and calculations built into Edit > Paste Special.įORMULA - you can display the formula for any cell.

Formulas en openoffice calc