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

[nikki]

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"..

 

[Pete_UK]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Pete_UK]

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3