| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need Blank column in invoice
Hi,
How can I make(or hide) contents of cell unless the cell before it isfilled in? Hope i said that right. My invoice has a payment col and balance col next to each other,. I want to have the formula in the balance column all the way down, but it should be emty until a payment is filled in? Thanks Frank |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Frank
Trap for no entry in the payment column by entering a formula in the balance column. =IF(payment_cellref="","",balance_formula) Gord Dibben MS Excel MVP On Wed, 19 Apr 2006 21:48:18 -0400, "Frank" wrote: Hi, How can I make(or hide) contents of cell unless the cell before it isfilled in? Hope i said that right. My invoice has a payment col and balance col next to each other,. I want to have the formula in the balance column all the way down, but it should be emty until a payment is filled in? Thanks Frank |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Gord,
Thank you, but I already have the balance minus payment formula in the balance col? How can I put both? formula is simple like =(d3-c4) where d is the balance and c is the payment.Sorry for the very basic question. thank you Frank "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Frank Trap for no entry in the payment column by entering a formula in the balance column. =IF(payment_cellref="","",balance_formula) Gord Dibben MS Excel MVP On Wed, 19 Apr 2006 21:48:18 -0400, "Frank" wrote: Hi, How can I make(or hide) contents of cell unless the cell before it isfilled in? Hope i said that right. My invoice has a payment col and balance col next to each other,. I want to have the formula in the balance column all the way down, but it should be emty until a payment is filled in? Thanks Frank |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
|
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
he meant if there was not a value in the cell show a blank,otherwise show
the formula. -- Don Guillett SalesAid Software "Frank" wrote in message ... Don, If I understood what he meant, I would not have posted again. I am not an idiot, just new to excel. Frank "Don Guillett" wrote in message ... Re-read Gord's post -- Don Guillett SalesAid Software "Frank" wrote in message ... Gord, Thank you, but I already have the balance minus payment formula in the balance col? How can I put both? formula is simple like =(d3-c4) where d is the balance and c is the payment.Sorry for the very basic question. thank you Frank "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Frank Trap for no entry in the payment column by entering a formula in the balance column. =IF(payment_cellref="","",balance_formula) Gord Dibben MS Excel MVP On Wed, 19 Apr 2006 21:48:18 -0400, "Frank" wrote: Hi, How can I make(or hide) contents of cell unless the cell before it isfilled in? Hope i said that right. My invoice has a payment col and balance col next to each other,. I want to have the formula in the balance column all the way down, but it should be emty until a payment is filled in? Thanks Frank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| extract key words/data from multiple files -dump in new worksheet | New Users to Excel | |||
| match and count words | Excel Worksheet Functions | |||
| Sum numbers based on the contents of another cell | Excel Worksheet Functions | |||
| how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) | |||
Hybrid Mode
