I think this should do it. Note that if more than one of the B5 has
data, Char(160) will be returned. But if all B5's are blank, then
you'll get Char(160), and if any one of them has data, you'll get that
data.

=IF(ISERROR(SUM(Sheet1!B5 & Sheet2!B5 &
Sheet3!B5)),CHAR(160),SUM(Sheet1!B5 & Sheet2!B5 & Sheet3!B5))


monkeyhop Wrote:
Clivey_UK:

I want to make a formula to do this:

IF Sheet1!B5 has data then enter that data to Sheet4!B10
elseif Sheet2!B5 has data then enter that data to Sheet4!B10
elseif Sheet3!B5 has data then enter that data to Sheet4!B10
else output CHAR(160) to Sheet4!B10


Thanks again in advance
monkeyhop


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=537772