Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
How can I have a value from one cell transferred to an adjacent cell when a
neighbouring cell is empty. Example: an amount invoiced to client is copied to another cell to be added where there is no invoice number entered. Purpose: values are entered when time sheets are completed. This provides a running balance of time not billed until an invoice number is entered,then the value opposite the invoice number is automatically omitted from the list. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
hi,
lets say that column a is where were enter the completed times Column b is where they are copied to until invoice. column c is invoice number in column b enter..... =if(C2="",A2,"") if c2 is empty, display A2 else display nothing. Regards FSt1 "Malcolm McMaster" wrote: How can I have a value from one cell transferred to an adjacent cell when a neighbouring cell is empty. Example: an amount invoiced to client is copied to another cell to be added where there is no invoice number entered. Purpose: values are entered when time sheets are completed. This provides a running balance of time not billed until an invoice number is entered,then the value opposite the invoice number is automatically omitted from the list. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Works for me many thanks
"FSt1" wrote: hi, lets say that column a is where were enter the completed times Column b is where they are copied to until invoice. column c is invoice number in column b enter..... =if(C2="",A2,"") if c2 is empty, display A2 else display nothing. Regards FSt1 "Malcolm McMaster" wrote: How can I have a value from one cell transferred to an adjacent cell when a neighbouring cell is empty. Example: an amount invoiced to client is copied to another cell to be added where there is no invoice number entered. Purpose: values are entered when time sheets are completed. This provides a running balance of time not billed until an invoice number is entered,then the value opposite the invoice number is automatically omitted from the list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |