if then

T

tmischler

Well-known Member

Joined

Jun 17, 2004

Messages

669

• Jan 18, 2005

• #2

=if(a1=13,"thirteen","not thirteen")

where a1 is the cell being evaluated, thirteen the value returned for true and not thirteen the value for false.

 

Upvote 0

erik.van.geit

MrExcel MVP

Joined

Feb 1, 2003

Messages

17,832

• Jan 18, 2005

• #3

Hi isacp,

If Cells(1,1) = "xx" Then
If Range("A1") = "xx" Then

look around in the codes all over the Board
use the "search" on top of the screen

You'll learn a lot

regards,
Erik

 

Upvote 0

M

martinee

Well-known Member

Joined

Nov 4, 2003

Messages

960

• Jan 18, 2005

• #4

Do you want code or formula?

Formula:

=IF(A1="xx", ReturnIfTrue, ReturnIfFalse)

Code:

IF Range("A1").Value = "xx" Then
'Do something if true
Else
'Do Something if False
End IF

HTH

 

Upvote 0

I

isacp

Board Regular

Joined

Dec 16, 2004

Messages

135

• Jan 18, 2005

• #5

cell a1 "sprint"

if a1="sp" then

this wont work for thi example.
but this is what i need.
to chose two letters in a string

 

Upvote 0

erik.van.geit

MrExcel MVP

Joined

Feb 1, 2003

Messages

17,832

• Jan 18, 2005

• #6

If Left(Range("A1"), 2) = "xx" Then MsgBox "xx"
attention: this is casesensitive
if it may not be casesensitive
If LCase(Left(Range("A1"), 2)) = "xx" Then MsgBox "xx"
If UCase(Left(Range("A1"), 2)) = "XX" Then MsgBox "xx"

regards,
Erik

 

Upvote 0

clipro

Board Regular

Joined

Jan 12, 2005

Messages

195

• Jan 18, 2005

• #7

Hi

try this

=IF(LEFT(A1;2)="sp";"You are lucky!";"Sorry. No match!")

Is this the exactly what are you looking for?

 

Upvote 0

M

martinee

Well-known Member

Joined

Nov 4, 2003

Messages

960

• Jan 18, 2005

• #8

Perhaps if the abbreviation is not at the begining of your text string:

Code:

If Instr(1,Range("A1"),"xx") > 0 Then
MsgBox "The string xx indeed appears in you search string."
End IF

HTH.

 

Upvote 0

I

isacp

Board Regular

Joined

Dec 16, 2004

Messages

135

• Jan 18, 2005

• #9

for each item in selection
if item.Left(Range("A1"), 2) = "St" Then
item.offset (0,1).select
selection.copy range("a1")
end if
next item


will this work?

 

Upvote 0

I

isacp

Board Regular

Joined

Dec 16, 2004

Messages

135

• Jan 18, 2005

• #10

If Item.Left = "O.D." Then
Item.Offset(0, 5).FormulaR1C1 = "O.D."
End If

this is what i have and it wont go?

 

Upvote 0