Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default IFBLANK

I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated
boxes that are blank but will show dates once data has been input.

eg:
A B C D
34 NAME DATE FUTUREDATE
35 John 15/03/10 =C35+(7*6)
36

D36 Cell shows as 11/02/1900 when C36 is not populated but want i to show
blank until it is populated when I want the formula to kick in.

Toby
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ifblank function [email protected] Excel Worksheet Functions 6 May 4th 09 05:51 PM
Help IfBlank use data from next cell quzie Excel Worksheet Functions 9 May 2nd 09 06:47 PM
if function and ifblank() function Bob Phillips Excel Worksheet Functions 3 September 25th 06 09:47 PM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"