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

basic excel training - formulas

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Formulas

basic excel training - Formulas

ResolvedVersion Standard

Sara has attended:
Excel Advanced course

Formulas

I would like to know the basic rules that a worksheet must adheer to for formulas to work. Very often I have the correct formul but it won't work because my spreadsheet is probably not in the correct fomat.

RE: Formulas

Hi Sara,

The basic rules for a formula to work is when you are in an empty cell the first thing you must press is = then you continue without spaces to insert you formula. Normally cell references are used, for example =A1+B1.

Can I ask what function or formula you are using, you may find the function itself has the wrong arguments in it, also what type of error message are you getting?

Let me know

Thanks for using the forum

Tracy

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.