The referenced web page says:
When an empty cell is filled with =NA(), Excel interpolates the missing
data, joining adjacent data points
I don't want the missing data points interpolated.
However, I went ahead and tried the NA() approach, as follows:
=IF('3'!B230,'3'!B23,NA())
But it just filled the cell with
#NA
--
MattBeckwith
------------------------------------------------------------------------
MattBeckwith's Profile:
http://www.excelforum.com/member.php...o&userid=30571
View this thread:
http://www.excelforum.com/showthread...hreadid=511363