View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TotallyConfused TotallyConfused is offline
external usenet poster
 
Posts: 144
Default IF with Search/Find???


I pressed the "Yes" button. Is there any other uses for "--"? Are there
any other situations where I could use? Thank you very much.


"Max" wrote:

Welcome, but pl take a moment to press the "Yes" button below

The "--" will coerce the TRUE/FALSE returns from the check:
LEFT(A5,3)="BSB"
to 1's/0's
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"TotallyConfused" wrote:
This worked!! Thank you so much. Can you please explain? I don't
understand the "--". First time I see this used. Thank you.