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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

ResolvedVersion 2016

Wed 31 Mar 2021, 20:34 Delegate Shilpa said...

Shilpa has attended:
Excel Advanced course

Formulas

I see"" this in betwene a lot of formulas. What does this mean?

Thu 1 Apr 2021, 00:05 Trainer Dennis said...

RE: Formulas

Hi Shilpa

When the double quotes "" are used like this it is to put nothing (NULL) in to a cell and display a blank cell instead of the default Excel response.

For example:

=IF(a5 >= 3, "pay bonus", "")

This would leave the cell blank instead of displaying FALSE

I hope this answers your question.

Regards

Dennis

Wed 7 Apr 2021: Automatically marked as resolved.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Quickly create a list of numbers