Numbers only

[Bal_Ocado]

A	B	C	D	E
Prod A	1234	yell	thi
Prod B	1234	owe	rfd
Prod C	rew	2344	feft
Prod D	yth	defg	3232

<tbody>
</tbody>

Hi Guys,

I have an issue with a formula I cannot resolve. As you can see from the table above,I have three rows of information, which I need to collate into 1. Essentially, one of the columns B,C or D has a price (number), the other two columns will not be a number but writing.

Unforunately, my data is a bit different, so the price will always be in one of the 3 columns. Is there a formula I can use in column E to always extract the number?

Thanks in advance!

 

[Alan_P]

Hi Bal_Ocado,

If the other 3 of the 4 columns are always text then you can just use Sum to extract the number?

=SUM(A1:D1)

Cheers,
Alan.

 

[a massive zebra]

In E2: =IF(ISNUMBER(B2),B2,IF(ISNUMBER(C2),C2,D2))

 

[Bal_Ocado]

Hi Alan,

This returns a 'VALUE' error for me?

Thanks

 

[Bal_Ocado]

Brilliant! Thanks