I have a set group of numbers associated with letters. I need to know what
formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the letter
show up inj another are.

Thanks:)

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


You can use a VLOOKUP formula; you can build a Vlookup table and use the
formula, or just incapsulate the table into the formula.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)

"Franz Verga" wrote:

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


You can use a VLOOKUP formula; you can build a Vlookup table and use the
formula, or just incapsulate the table into the formula.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

what you require is "nested if". see help "if" and examples therein. you
have to enter the formula in the cell 2.


"snwooz" wrote in message
...
I have a set group of numbers associated with letters. I need to know what
formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter
show up inj another are.

Thanks:)

OK, first post put me on the right track. I have on that works, now i need
to it work for all 5 numbers.

Thanks

"R..VENKATARAMAN" wrote:

what you require is "nested if". see help "if" and examples therein. you
have to enter the formula in the cell 2.


"snwooz" wrote in message
...
I have a set group of numbers associated with letters. I need to know what
formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter
show up inj another are.

Thanks:)

snwooz wrote:
I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)

"Franz Verga" wrote:

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

PERFECT!!!! tHANKS:)

"Franz Verga" wrote:

snwooz wrote:
I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)

"Franz Verga" wrote:

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

IS it possible to set the formula to go either way. If A1 and B1 are my
input cells, can the formula work so that if I put in 1.26 in A1, G comes up
in B1 or if I put G in B1, 1.26 comes up in A1?

"Franz Verga" wrote:

snwooz wrote:
I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)

"Franz Verga" wrote:

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

You have to decide which are your input cells and which are the result
cells: in a cell you can have a result from a formula or an input, not
both...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

"snwooz" ha scritto nel messaggio
...
IS it possible to set the formula to go either way. If A1 and B1 are my
input cells, can the formula work so that if I put in 1.26 in A1, G comes
up
in B1 or if I put G in B1, 1.26 comes up in A1?

"Franz Verga" wrote:

snwooz wrote:
I am still confused. My table looks like this:

1 2

A 1.26 G

B 1.22 C

Can you please offer example. Don't use this much :)

"Franz Verga" wrote:

snwooz wrote:
I have a set group of numbers associated with letters. I need to
know what formula I would use to accomplish the following:

if (cell #1 = 1.26 then (Cell #2) = G
f (cell #1 = 1.22 then (Cell #2) = c

and so on. I would like to be able to input the number and have the
letter show up inj another are.

Thanks:)


=VLOOKUP(A1,{1.26,"G";1.22,"C"},2,0)

where A1 is your input cell.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy