excel microsoft training - cell reference

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Cell reference

excel microsoft training - Cell reference

resolvedResolved · Low Priority · Version Standard

Elena has attended:
Excel Advanced course

Cell reference

how to create cell reference?

RE: cell reference

Hi Elena,

Thanks for your question. A cell reference = cell address, always start with Column Letter, followed by Row Number.

e.g. cell H23

To insert a cell reference, simply type in = sign & use the mouse to click on a cell, then press ENTER.

See if that helps.

Regards,

Katie


 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Server loaded in 0.08 secs.