| 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? |
| 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 | |||
Threaded Mode
