View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default if cell is blank

Hi Mark,

Am Fri, 28 Jun 2013 23:45:32 +0100 schrieb Mark74w1:

I copied and pasted the formula and got a #REF! Error.
I checked that the formula spelled out correct places and it seems
correct.


the formula is tested and it works well. Did you pay attention about the
line break?


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2