Excel Formula

  • Thread starter Malcolm McMaster
  • Start date
M

Malcolm McMaster

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.
 
F

FSt1

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
 
M

Malcolm McMaster

Works for me many thanks

FSt1 said:
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
 
Top