Re: IF OR Formula
- From: "CLR" <croberts@xxxxxxxxxxxxxxx>
- Date: Sat, 9 Apr 2005 13:28:30 -0400
"OR", a little shorter version............
=IF(OR(B2="",B2=" ",ISNUMBER(LEFT(B2,6)*1)),"",B2)
Vaya con Dios,
Chuck, CABGx3
"Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx> wrote in message
news:#PjFVZSPFHA.2252@xxxxxxxxxxxxxxxxxxxxxxx
> Do we need the TRUE?
>
> =IF(OR(B2="",B2=" "),"",IF(ISNUMBER(VALUE(LEFT(B2,6))),"",B2))
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
>
.
- References:
- Re: IF OR Formula
- From: Bernard Liengme
- Re: IF OR Formula
- Prev by Date: Re: IF OR Formula
- Next by Date: sortable list
- Previous by thread: Re: IF OR Formula
- Next by thread: sortable list
- Index(es):
Relevant Pages
|
