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 2003

Wed 14 Apr 2010, 09:46 Delegate Dee said...

Dee has attended:
Excel Advanced course
Excel Intermediate course

Formulas

I am trying to sort out a spreadsheet with existing formulas. In the formula =IF(B6="","",B6-B5), what does the "" mean?

Wed 14 Apr 2010, 11:04 Trainer Anthony said...

RE: formulas

Hi Dee, thanks for your query. It might help to express the formula more literally:

IF B6 is equal to the value "" then put "" in this cell, otherwise put the value of B6-B5 into this cell

Basically, the formula is testing for null values. If it finds one, it doesn't do anything, but if there is a value in B6 it will subtract from it that value in B5.

Hope this helps,

Anthony

Wed 14 Apr 2010, 11:04 Trainer Anthony said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

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

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Hiding Formulae in the Formula Bar