Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Date & Time Custom Cell - Need to show blank!
I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is
also a formula that adds a day if certain conditions are met. When I copy this formula down so that every cell has it, the cells on rows that haven't been used yet show as 01/01/1900 00:00. How do I show these as blank cells - the sheet is quite confusing otherwise! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Date & Time Custom Cell - Need to show blank!
JDB
Use an IF function around your current formula checking for a blank in the cell that will eventually be filled out (In my example A1) =IF(A1="","",A1+1) (These are two double-quotes, "") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "JDB" wrote in message ... I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is also a formula that adds a day if certain conditions are met. When I copy this formula down so that every cell has it, the cells on rows that haven't been used yet show as 01/01/1900 00:00. How do I show these as blank cells - the sheet is quite confusing otherwise! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Date & Time Custom Cell - Need to show blank!
This doesn't seem to work. Firstly, it says that this creates a circular
reference. I should have pointed out that the actual formula that is already in the cells is as follows: IF((E3="Y"),"",(B3+1)) Column E is a Y or N answer to whether a particular action has been completed within 24 hours of the original date. If it hasn't, an email needs to be sent 24 hours after the original date. The original date is column B. "Nick Hodge" wrote: JDB Use an IF function around your current formula checking for a blank in the cell that will eventually be filled out (In my example A1) =IF(A1="","",A1+1) (These are two double-quotes, "") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "JDB" wrote in message ... I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is also a formula that adds a day if certain conditions are met. When I copy this formula down so that every cell has it, the cells on rows that haven't been used yet show as 01/01/1900 00:00. How do I show these as blank cells - the sheet is quite confusing otherwise! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Date & Time Custom Cell - Need to show blank!
"JDB" wrote in message
... "Nick Hodge" wrote: "JDB" wrote in message ... I have a column with the cells formatted to show dd/mm/yyyy hh:mm. There is also a formula that adds a day if certain conditions are met. When I copy this formula down so that every cell has it, the cells on rows that haven't been used yet show as 01/01/1900 00:00. How do I show these as blank cells - the sheet is quite confusing otherwise! Use an IF function around your current formula checking for a blank in the cell that will eventually be filled out (In my example A1) =IF(A1="","",A1+1) (These are two double-quotes, "") This doesn't seem to work. Firstly, it says that this creates a circular reference. I should have pointed out that the actual formula that is already in the cells is as follows: IF((E3="Y"),"",(B3+1)) Column E is a Y or N answer to whether a particular action has been completed within 24 hours of the original date. If it hasn't, an email needs to be sent 24 hours after the original date. The original date is column B. So taking what Nick suggested, and including that logic in your formula: =IF((E3="Y"),"",(IF(B3="","",B3+1))) -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |