Adding a cell reference to an if then function
 

I have the following function:
=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))

and after the then statement I need it to read a number from a relative cell
reference. But when I try to reference a cell inside the function it only
copies the name of the cell (ex. E6) and won't actually copy the contents of
the cell. If I try to reference the cell outside of the function it doesn't
work and I get a reference error message.

Any ideas?

Adding a cell reference to an if then function
 

Do you want the same cell reference to apply to every IF?

Try it like this:

=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))&" "&E6


--
Biff
Microsoft Excel MVP


"Timmah18" wrote in message
...
I have the following function:
=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))

and after the then statement I need it to read a number from a relative
cell
reference. But when I try to reference a cell inside the function it only
copies the name of the cell (ex. E6) and won't actually copy the contents
of
the cell. If I try to reference the cell outside of the function it
doesn't
work and I get a reference error message.

Any ideas?

Adding a cell reference to an if then function
 

OMG that worked. I don't understand how it works though, what does the &" "
& mean and why couldn't I just use the standard cell reference (=E6)?

"T. Valko" wrote:

Do you want the same cell reference to apply to every IF?

Try it like this:

=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))&" "&E6


--
Biff
Microsoft Excel MVP


"Timmah18" wrote in message
...
I have the following function:
=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))

and after the then statement I need it to read a number from a relative
cell
reference. But when I try to reference a cell inside the function it only
copies the name of the cell (ex. E6) and won't actually copy the contents
of
the cell. If I try to reference the cell outside of the function it
doesn't
work and I get a reference error message.

Any ideas?

Adding a cell reference to an if then function
 

The & is the concatenation operator.

&" " concatenates a space
&E6 concatenates the value of cell E6

The concatenation operator does the same thing as the CONCATENATION function
but is easier and results in a shorter formula.

Both of these formulas do the same thing:

A1 = Try
B1 = this

=A1&" "&B1
=CONCATENATE(A1," ",B1)

Both return: Try this

--
Biff
Microsoft Excel MVP


"Timmah18" wrote in message
...
OMG that worked. I don't understand how it works though, what does the &"
"
& mean and why couldn't I just use the standard cell reference (=E6)?

"T. Valko" wrote:

Do you want the same cell reference to apply to every IF?

Try it like this:

=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))&" "&E6


--
Biff
Microsoft Excel MVP


"Timmah18" wrote in message
...
I have the following function:
=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))

and after the then statement I need it to read a number from a relative
cell
reference. But when I try to reference a cell inside the function it
only
copies the name of the cell (ex. E6) and won't actually copy the
contents
of
the cell. If I try to reference the cell outside of the function it
doesn't
work and I get a reference error message.

Any ideas?

Adding a cell reference to an if then function
 

Look in Excel help for the CONCATENATE function and find the associated
topic "Combine text and numbers".
--
David Biddulph

"Timmah18" wrote in message
...
OMG that worked. I don't understand how it works though, what does the &"
"
& mean and why couldn't I just use the standard cell reference (=E6)?

"T. Valko" wrote:

Do you want the same cell reference to apply to every IF?

Try it like this:

=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))&" "&E6


--
Biff
Microsoft Excel MVP


"Timmah18" wrote in message
...
I have the following function:
=IF(H4="Like_New","Great condition, may contain minor
wear",IF(H4="Very_Good","Contains considerable wear, still very usable
though",IF(H4="Brand_New","MINT")))

and after the then statement I need it to read a number from a relative
cell
reference. But when I try to reference a cell inside the function it
only
copies the name of the cell (ex. E6) and won't actually copy the
contents
of
the cell. If I try to reference the cell outside of the function it
doesn't
work and I get a reference error message.

Any ideas?