answersLogoWhite

0


Best Answer

Any formula can use B20. There is no limit. Here are some:

=B20+10

=B20*4

=SUM(B20:B45)

=B20/100

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What formula in Excel references b20?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is B20 in excel?

It is the reference to the cell formed where column B meets row 20.


Excel formula to add column but omit negative numbers?

You could use the SUMIF function. The range of cells to add are in the first part of the formula and the condition is enclosed in quotation marks. Say your values are in the all cells in column B from B1 to B20. Then in another cell your formula would be: =SUMIF(B1:B20,">0") This will add all the values from B1 to B20 that are greater than zero.


What are color coded formula references in Excel?

To make it easier to see what parts of a formula refer to what cells or references on a worksheet, the cell references in the formula are shown in colour and highlights around the cells are in the corresponding colours.


In excel if you copy a formula to another location and the cell references change to reflect the position of its copied location the formula contains a what?

It contains relative cell references.


What changes when it is copied or moved in Excel?

Relative cell references and some mixed cell references will change when a formula is copied.


What is an absolute formula in Excel?

It would be a formula that includes absolute references in cells. When such a formula is copied, those cell references will not change. An absolute cell reference includes cell references with two dollar signs in them, like: $A$2.


What consists of cell references numbers and arithmetic operators that instruct Excel to perform a calculation?

A formula.


Which function of Excel does not work with 3D formulas?

There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.


How can insert a row in excel sheet without changing the formula?

Change the formula to use absolute references instead of relative references. Instead of =A2+B3, use =$A$2+$B$3.


How can you check and correct your Lewis structure?

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.


What is the definition Point Mode for Excel 2007?

In Excel it allows you to enter formulas using the mouse, by clicking on cells as you type a formula, instead on typing the cell references.


What is an easy way to verify that a formula references the cells that you want it to reference in excel?

Use absolute references (e.g. $C$3) instead of relative references (e.g. C3). See related questions for more information about absolute references.