| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function which returns the text from a cell
Is it somehow possible to make a IF function which returns the text (e.g.
someone's name) from one cell if the value in another cell is correct. I only know how to make an IF function which returns a NUMBER value. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function which returns the text from a cell
Yes it is possible, you just reference the cell with the name in or put the name in " " in your if statement If that is insufficient perhaps you can provide more details what you require and i may be able to give a better answer Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=558770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function that will = 1 of 4 cell containing text | Excel Worksheet Functions | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
