If then nested with isblank count blank?

[kmprice710]

I have four columns of pricing data. If columns A, B, C are all blank, then I want to output whatever is in column D. If Columns A & B are blank but something is in C, then I want C. If Columns A & C are blank, but something is in B, then I want B. If Columns B & C are blank but something is in A, then I want A. There's never a case of something being in A & B, A & C or B & C at the same time.

I think I can write this with an IF/THEN using ISBLANK or COUNTBLANK, but how do I nest it?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]5.66
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3.24[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6.75[/TD]
[TD][/TD]
[TD]18.99[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]17.15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]7.82[/TD]
[TD]22.25
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

Excel 2010
	A	B	C	D	E
1	5.66			3.24	5.66
2		6.75		18.99	6.75
3				17.15	17.15
4			7.82	22.25	7.82
Sheet1

Cell Formulas
Range	Formula
E1	=IF(A1<>"",A1,IF(B1<>"",B1,IF(C1<>"",C1,D1)))
E2	=IF(A2<>"",A2,IF(B2<>"",B2,IF(C2<>"",C2,D2)))
E3	=IF(A3<>"",A3,IF(B3<>"",B3,IF(C3<>"",C3,D3)))
E4	=IF(A4<>"",A4,IF(B4<>"",B4,IF(C4<>"",C4,D4)))

 

[Scott Huish]

=INDEX(A1:D1,MATCH(TRUE,A1:D1<>"",0))
Confirm with CTRL-SHIFT-ENTER rather than just Enter and copy down.

Excel 2010
	A	B	C	D	E	F	G
1	5.66			3.24			5.66
2		6.75		18.99			6.75
3				17.15			17.15
4			7.82	22.25			7.82
Sheet1

Cell Formulas
Range	Formula
G1	{=INDEX(A1:D1,MATCH(TRUE,A1:D1<>"",0))}
G2	{=INDEX(A2:D2,MATCH(TRUE,A2:D2<>"",0))}
G3	{=INDEX(A3:D3,MATCH(TRUE,A3:D3<>"",0))}
G4	{=INDEX(A4:D4,MATCH(TRUE,A4:D4<>"",0))}
Press CTRL+SHIFT+ENTER to enter array formulas.