Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into anoth
I have a very elaborate spreadsheet that is used by most of the people in my
office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed intoanoth
If(BK2="","",BK2+30)
akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
I truely have no idea what that means. I know how to create the formula, but
I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
This means that you put a formula in the other cell--but it evaluates to what
looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
Ok... I get it now. Thanks a bunch!!
"Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
One more Question.....
How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed intoa
If(OR(BK2="",BL2=""),"",BK2+BL2+120)
akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
Another way:
=if(count(bk2:bl2)<2,"",sum(bk2:bl2,120)) (Just to be a little different.) akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
This post helped me TREMENDOUSLY. However, I have another variation:
so I'm using the formula =IF(B10="","",B10+14) and that works good. But to really be accurate with my dates, I need to calculate a date that's 10 business days in the future using the WORKDAY function, AND how to make that formula not appear on my spreadsheet until a value is entered. Can you help? "Bob I" wrote: If(OR(BK2="",BL2=""),"",BK2+BL2+120) akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
Try this:
=IF(B10="","",WORKDAY(B10,10)) Format the cell as Date. -- Biff Microsoft Excel MVP "cashnic" wrote in message ... This post helped me TREMENDOUSLY. However, I have another variation: so I'm using the formula =IF(B10="","",B10+14) and that works good. But to really be accurate with my dates, I need to calculate a date that's 10 business days in the future using the WORKDAY function, AND how to make that formula not appear on my spreadsheet until a value is entered. Can you help? "Bob I" wrote: If(OR(BK2="",BL2=""),"",BK2+BL2+120) akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
works perfectly, thank you!!
"T. Valko" wrote: Try this: =IF(B10="","",WORKDAY(B10,10)) Format the cell as Date. -- Biff Microsoft Excel MVP "cashnic" wrote in message ... This post helped me TREMENDOUSLY. However, I have another variation: so I'm using the formula =IF(B10="","",B10+14) and that works good. But to really be accurate with my dates, I need to calculate a date that's 10 business days in the future using the WORKDAY function, AND how to make that formula not appear on my spreadsheet until a value is entered. Can you help? "Bob I" wrote: If(OR(BK2="",BL2=""),"",BK2+BL2+120) akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you hide the value of a cell until data is keyed into a
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "cashnic" wrote in message ... works perfectly, thank you!! "T. Valko" wrote: Try this: =IF(B10="","",WORKDAY(B10,10)) Format the cell as Date. -- Biff Microsoft Excel MVP "cashnic" wrote in message ... This post helped me TREMENDOUSLY. However, I have another variation: so I'm using the formula =IF(B10="","",B10+14) and that works good. But to really be accurate with my dates, I need to calculate a date that's 10 business days in the future using the WORKDAY function, AND how to make that formula not appear on my spreadsheet until a value is entered. Can you help? "Bob I" wrote: If(OR(BK2="",BL2=""),"",BK2+BL2+120) akemeny wrote: One more Question..... How would I word that if I wanted to do more than one column. IE: BK2+BL2+120 "Dave Peterson" wrote: This means that you put a formula in the other cell--but it evaluates to what looks like an empty cell until you put something in BK2. akemeny wrote: I truely have no idea what that means. I know how to create the formula, but I need to know how to make that formula not appear on my spreadsheet until a value is entered into (what I'm calling) BK2. "Bob I" wrote: If(BK2="","",BK2+30) akemeny wrote: I have a very elaborate spreadsheet that is used by most of the people in my office. I have three columns that contain formulas that calculate 30, 60 & 120 days from the date keyed into a specific column (ie: =bk2+30). Before a date is entered into [bk2] the date that is displayed is a standard date 1/30/00. I know that you can hide anything that has a zero in that column, but how do you hide that date until an actual date is keyed into [bk2]? Is that even possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro needed to compare value and copy data underneath it to anoth | Excel Discussion (Misc queries) | |||
How do I get a cell to count values from a list dependent on anoth | Excel Worksheet Functions | |||
clicking cell containing text, and a numeric value appear in anoth | Excel Discussion (Misc queries) | |||
How to prevent copied data from appearing until triggered by anoth | Excel Worksheet Functions | |||
how can i test whether cell contains keyed constant or a formulae | Excel Worksheet Functions |