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.

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.

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.