Can I use a between clause or in clause on an IF statement

's Computer Specifications

I have this statement in a cell:

=IF(RIGHT(C12,1)="1",TEXT(0,"00")

Which states that when C12 last digit ends in a 1 then put 00 in C13

I want to do the same if C12 last digit ends in [A]-[E] I know how to do it
in SQL not in Excel programming though.

thanks

's Computer Specifications

=IF(OR(RIGHT(C12,1)="1",AND(UPPER(RIGHT(C12,1))>="A",UPPER(RIGHT(C12,1))<="E")),"00","")

--
Regards,
Tom Ogilvy

"ssciarrino" wrote:

> I have this statement in a cell:
>
> =IF(RIGHT(C12,1)="1",TEXT(0,"00")
>
> Which states that when C12 last digit ends in a 1 then put 00 in C13
>
> I want to do the same if C12 last digit ends in [A]-[E] I know how to do it
> in SQL not in Excel programming though.
>
> thanks
>
>

's Computer Specifications

Thanks tom

"Tom Ogilvy" wrote:

> =IF(OR(RIGHT(C12,1)="1",AND(UPPER(RIGHT(C12,1))>="A",UPPER(RIGHT(C12,1))<="E")),"00","")
>
> --
> Regards,
> Tom Ogilvy
>
>
> "ssciarrino" wrote:
>
> > I have this statement in a cell:
> >
> > =IF(RIGHT(C12,1)="1",TEXT(0,"00")
> >
> > Which states that when C12 last digit ends in a 1 then put 00 in C13
> >
> > I want to do the same if C12 last digit ends in [A]-[E] I know how to do it
> > in SQL not in Excel programming though.
> >
> > thanks
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If statement in Where Clause of SQL?	BlueWolverine	Microsoft Access Queries	1	10th Dec 2008 01:58 PM
Re: If statement in Where Clause of SQL?	Stefan Hoffmann	Microsoft Access Queries	0	9th Dec 2008 03:10 PM
How to add an AND clause to a function statement	Dean Slindee	Microsoft Access Reports	2	6th Nov 2006 08:22 PM
adjusting where clause in SQL statement	=?Utf-8?B?Sm9zaCBIZW5yeQ==?=	Microsoft Access Queries	0	30th Nov 2004 04:01 PM
sql statement with if clause?	Dan Nash	Microsoft Access Queries	3	10th Dec 2003 02:07 PM