How do I make 1 letter = another

[Jack-P-Winner]

I have many rows in a spreadsheet. How can I make 1 letter equal another for example:

O=D
E=U

 

[rrocker1405]

Hi,

I think you wanted to have something like this...insert the below formula in cell a1.

=IF(B1="O","D",IF(B1="E","U"))

Regards,
A!

 

[Luke M]

Que? Not sure what you mean. To quote Scotty: "I cannae change the laws of physics!"

 

[Jack-P-Winner]

Hi,

I think you wanted to have something like this...insert the below formula in cell a1.

=IF(B1="O","D",IF(B1="E","U"))

Regards,
A!

You da man rr!!! THANK YOU!!!

 

[Khalid NGO]

Hi Larry,

Since there are only 2 type of returns, i.e. "D" & "U"
I think above formula can be simplified with just one if statement:
=IF(B1="O","D","U")

Regards,

 

[Jack-P-Winner]

Hi Larry,

Since there are only 2 type of returns, i.e. "D" & "U"
I think above formula can be simplified with just one if statement:
=IF(B1="O","D","U")

Regards,

Thanks, but I also need E

 

[Khalid NGO]

Thanks, but I also need E

so its working with E:
if you type E in B1 both formulas will return "U"
if you type O in B1 both will return "D"

 

[Khalid NGO]

But you type other than "O" 1st formula will return FALSE
and 2nd will remain with "U"