| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PERCENTILE with an IF Clause | Excel Worksheet Functions | |||
| IF Clause | Excel Worksheet Functions | |||
| IF Clause | Excel Programming | |||
| "Between" in an IF clause | Excel Discussion (Misc queries) | |||
| Where Clause Errors | Excel Programming | |||
Linear Mode
