IF Statement

Resolved · Medium Priority · Version 2010

Fri 15 Jul 2016, 16:18 Delegate Andrew said...

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Dashboards for Business Intelligence course

IF Statement

In Cell A2 I have a start date
The completion date in B2 is blank
In C2 I am simply calculating the days between B2 and A2, but because B2 is blank, C2 is showing a -42492 figure

How can I keep cell C2 blank " " whilst the completion date is unknown?

This is the formula I currently have that shows -42495

=IF(B2-A2=0," ",B2-A2)

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

IF Statement

IF Statement

Excel articles

Excel tip:

Repeating headings on spreadsheets that print on more than one page