| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating a cell based on a range of values (Part III) | New Users to Excel | |||
| Populating a Cell based on a Range of Values (Part II) | New Users to Excel | |||
| Populating a cell based on a range of values | New Users to Excel | |||
| populating a cell based on another range of cells in excel | Excel Discussion (Misc queries) | |||
| populating a cell will a value from a range of cells | Excel Programming | |||
Linear Mode
