"if" statement help... please!!??
 

anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki

"if" statement help... please!!??
 

RIGHT(B1,1) will return the last character of B1, so you could write:

=IF(RIGHT(B1,1)="7",B1+4,B1+11)

Note that RIGHT returns a string - hence the quotes.

Hope this helps.

Pete

On Feb 7, 3:04*pm, nikki wrote:
anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki

"if" statement help... please!!??
 

=IF(RIGHT(B1,1)=7,B1+4,B1+11)

Vaya con Dios,
Chuck, CABGx3



"nikki" wrote:

anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki

"if" statement help... please!!??
 

Good one Pete..........my bad.

Vaya con Dios,
Chuck, CABGx3




"Pete_UK" wrote:

RIGHT(B1,1) will return the last character of B1, so you could write:

=IF(RIGHT(B1,1)="7",B1+4,B1+11)

Note that RIGHT returns a string - hence the quotes.

Hope this helps.

Pete

On Feb 7, 3:04 pm, nikki wrote:
anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki

"if" statement help... please!!??
 

OOOPS, forgot the quotes..........see Pete's answer

=IF(RIGHT(B1,1)="7",B1+4,B1+11)

Vaya con Dios,
Chuck, CABGx3




"CLR" wrote:

=IF(RIGHT(B1,1)=7,B1+4,B1+11)

Vaya con Dios,
Chuck, CABGx3



"nikki" wrote:

anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki

"if" statement help... please!!??
 

Hi Chuck,

Google Groups has been acting up for a week or so and is not showing
all posts - I can see your earlier posting by using OE, but not
through this portal (which I've gotten used to, so tend to use most
often), so this posting of yours was a bit of a surprise.

I nearly missed the quotes myself !! <bg

Pete

On Feb 7, 3:29*pm, CLR wrote:
Good one Pete..........my bad.

Vaya con Dios,
Chuck, CABGx3



"Pete_UK" wrote:
RIGHT(B1,1) will return the last character of B1, so you could write:

=IF(RIGHT(B1,1)="7",B1+4,B1+11)

Note that RIGHT returns a string - hence the quotes.

Hope this helps.

Pete

On Feb 7, 3:04 pm, nikki wrote:
anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki- Hide quoted text -

- Show quoted text -

"if" statement help... please!!??
 

Yeah, that's what I get for not testing........gotta remember, TEST, TEST,
TEST!!!

Vaya con Dios,
Chuck, CABGx3


"Pete_UK" wrote:

Hi Chuck,

Google Groups has been acting up for a week or so and is not showing
all posts - I can see your earlier posting by using OE, but not
through this portal (which I've gotten used to, so tend to use most
often), so this posting of yours was a bit of a surprise.

I nearly missed the quotes myself !! <bg

Pete

On Feb 7, 3:29 pm, CLR wrote:
Good one Pete..........my bad.

Vaya con Dios,
Chuck, CABGx3



"Pete_UK" wrote:
RIGHT(B1,1) will return the last character of B1, so you could write:

=IF(RIGHT(B1,1)="7",B1+4,B1+11)

Note that RIGHT returns a string - hence the quotes.

Hope this helps.

Pete

On Feb 7, 3:04 pm, nikki wrote:
anyone know if you can write in an if statement "=if(B1"ends with a 7",B1+4,
B1+11)??? I don't know how to say "ends with a 7"..
--
nikki- Hide quoted text -

- Show quoted text -