Formulas

Resolved · Low Priority · Version 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:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Formulas

Formulas

RE: formulas

Will be marked as resolved in 5 days

Excel articles

Excel tip:

LARGE and SMALL functions and their uses