It should show 0 unless A5 has a blank space or spaces in it (in which case
it is not empty).

Also, I get a #VALUE! error rather than "#N/A!".

--

Vasant


"Man Utd" wrote in message
...
I got a cell has a formula refering to a cell, say =2*A5, however, if the
referred cell(A5) is empty, this referring cell will display a string
"#N/A".
How do I display this referring cell empty rather than "#N/A" if the cell
A5
is empty?