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

excel formulas

ResolvedVersion Standard

Joanne has attended:
Excel Intermediate course

Excel formulas

How and when do you use "" in formulas? What do they mean?

RE: Excel formulas

This depends on the formula really, there are many. It basically means when there is zero length string (no text). In an if statement you might say if there is no or a zero then enter 'No Value' in the field.

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

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.08 secs.