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 |
All times are GMT +1. The time now is 03:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com