| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to the row digit in the cell reference | Excel Discussion (Misc queries) | |||
| adding a formula around a cell reference | Excel Discussion (Misc queries) | |||
| adding cell reference on a header | Excel Worksheet Functions | |||
| Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
| What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions | |||
Linear Mode
