Try:

=IF(COUNT(A1,A3,A5,A7,A9,A11)=1,MAX(A1,A3,A5,A7,A9 ,A11),"")
--
Gary's Student


"Spreadsheet" wrote:


I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=557389