Thread: populating a cell will a value from a range of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default populating a cell will a value from a range of cells
=IF(NOT(ISBLANK(B1)),B1,A1)

--
Gary''s Student


"leo" wrote:

i want to put in column c the value from coulmn B if there is a value in
columns A or B. If there is a value in column A only then populate with that
value.

for example

A B C
1 1
2 3 3
2 2
Reply With QuoteReply With Quote