| 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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Well Don,
Thanks for trying, but at this point I will give up and suffer through what I have set up already. You see, I understand what his formula is saying, sort of, but I do not understand where it goes. If I put it in a cell in the balance column, then I have no formula for sutracting the pymt from the balance.Maybe I am describing it wrong, very possible indeed. Col A is the date of pymt.(no formula, just formatted for date) Col B is the payment .(no formula, just formatted for currency) Col C is the remaining balance with the formula for subtracting pymt from beginning balance, leaving value of remaining balance in col C.. Whew!! Thanks for trying, Frank "Don Guillett" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Frank
A few assumptions........... You have a payment in B1 of $123 You have a starting balance in C1 of $562 In C2 enter =IF(B1="","",C1-B1) Drag/copy that formula down a ways then start pounding payments into column B Gord On Thu, 20 Apr 2006 11:42:02 -0400, "Frank" wrote: Well Don, Thanks for trying, but at this point I will give up and suffer through what I have set up already. You see, I understand what his formula is saying, sort of, but I do not understand where it goes. If I put it in a cell in the balance column, then I have no formula for sutracting the pymt from the balance.Maybe I am describing it wrong, very possible indeed. Col A is the date of pymt.(no formula, just formatted for date) Col B is the payment .(no formula, just formatted for currency) Col C is the remaining balance with the formula for subtracting pymt from beginning balance, leaving value of remaining balance in col C.. Whew!! Thanks for trying, Frank "Don Guillett" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Hurray, It Works!
Thanks Gord and thanks to Don also. I am studying as much as I can so I can understand better. frank "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Frank A few assumptions........... You have a payment in B1 of $123 You have a starting balance in C1 of $562 In C2 enter =IF(B1="","",C1-B1) Drag/copy that formula down a ways then start pounding payments into column B Gord On Thu, 20 Apr 2006 11:42:02 -0400, "Frank" wrote: Well Don, Thanks for trying, but at this point I will give up and suffer through what I have set up already. You see, I understand what his formula is saying, sort of, but I do not understand where it goes. If I put it in a cell in the balance column, then I have no formula for sutracting the pymt from the balance.Maybe I am describing it wrong, very possible indeed. Col A is the date of pymt.(no formula, just formatted for date) Col B is the payment .(no formula, just formatted for currency) Col C is the remaining balance with the formula for subtracting pymt from beginning balance, leaving value of remaining balance in col C.. Whew!! Thanks for trying, Frank "Don Guillett" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
need Blank column in invoice
Frank,
Earlier, in one of your posts, you mentioned that you use the Club Connect Software at work. I am trying to find out if there is any sort of softcopy documentation available for it. I can explain more in detail offline if you would like. Thanks..... |
| 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) | |||
Linear Mode
