Prev: How to find a value with multi-column, multi-record list
Next: CONVERT function for Excel 2003
From: Malcolm on 30 May 2010 19:16
To the 3 Great Minds,
Thanks guys, they all worked. You all must have very strong necks to support
those giant brains. Could you modify the formula to only work in the
destination cell if the letter "S" is entered in the source cell? Again
thanks to all 3.
Best Regards,
Malcolm

"Gord Dibben" wrote:

> Always tweaking<g>
>
> Shorter and more readable.
>
> Thanks Biff
>
>
> Gord
>
> On Sun, 30 May 2010 12:21:34 -0400, "T. Valko" <biffinpitt(a)comcast.net>
> wrote:
>
> >Another way to write the same formulas already suggested...
> >
> >=IF(OR('End Bal'!B5={"","No Show"}),"",'End Bal'!B5)
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: How to find a value with multi-column, multi-record list
Next: CONVERT function for Excel 2003