IF X = Reverse of Y True = 1 False = 0
 

How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?

IF X = Reverse of Y True = 1 False = 0
 

Define reverse.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brad Larsen" wrote in message
...
How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of
cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?

IF X = Reverse of Y True = 1 False = 0
 

in your cell =if(x=1/y,1,0)
--
paul
remove nospam for email addy!



"Brad Larsen" wrote:

How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?

IF X = Reverse of Y True = 1 False = 0
 

yes=sey ?
102=201 ?

Biff

"Bob Phillips" wrote in message
...
Define reverse.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brad Larsen" wrote in message
...
How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of
cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?

IF X = Reverse of Y True = 1 False = 0
 

If the cell reads "1-2-4-3-7-6"
I want it to check for a reverse of "6-7-3-4-2-1"

Thanks for your help.

"Bob Phillips" wrote:

Define reverse.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Brad Larsen" wrote in message
...
How do i get excel to do this?

I want the formula to look at cell 3D and if it is the exact reverse of
cell
3B then enter 1 in cell 3E or if it's not enter 0 in 3E.

How can i do this?