View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Source and Destination worksheet difference

Always tweaking<g

Shorter and more readable.

Thanks Biff


Gord

On Sun, 30 May 2010 12:21:34 -0400, "T. Valko"
wrote:

Another way to write the same formulas already suggested...

=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)