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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can I use a between clause or in clause on an IF statement (https://www.excelbanter.com/excel-programming/388753-can-i-use-between-clause-clause-if-statement.html)

ssciarrino

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

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

Tom Ogilvy

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

=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

ssciarrino

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

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

All times are GMT +1. The time now is 07:22 AM.