Formula to consolidate two different columns

[gigglesxx]

Hi,

I am trying to create a formula which looks at two different columns (1 and 2 in this example) and returns the value if there is one in either column 1 or column 2. And if both columns are empty, then leave the cell empty.

For example for the first row, the formula would return $205 and for the second row it would return $204. I am trying to consolidate the two columns into the one

Any help would be much appreciated!

average weighted rate (all)	1	2
		$205
	$204
		$216
	$200
	$220
	$300
	$290
	$290
	$300

<tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody></tbody>

 

[Yongle]

Re: Formula to consolidate two different columns. help!

Columns A,B,C
Excel 2016 (Windows) 32 bit

		Result​
	$205​	$205​
$204​		$204​
	$216​	$216​
$200​		$200​
$220​		$220​
$300​		$300​
$290​		$290​
$290​		$290​
$300​		$300​

<tbody>
</tbody>

Sheet: Sheet2

<tbody>
</tbody>

Formula in C2 copied down
Excel 2016 (Windows) 32 bit

=IF(ISBLANK(A2),B2,A2)​

<tbody>
</tbody>

Sheet: Sheet2

<tbody>
</tbody>