| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with formula...if -- concatenate
=IF(A4<"","=CONCATENATE(sheet1!A4,sheet2!B4,"txt" )","")
is this possible? where am I going wrong? sorry to be a pain! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula...if -- concatenate
Nel post
*sedonovan* ha scritto: =IF(A4<"","=CONCATENATE(sheet1!A4,sheet2!B4,"txt" )","") is this possible? where am I going wrong? sorry to be a pain! Hi Sedonovan. Two way: =IF(A4<"",CONCATENATE(sheet1!A4,sheet2!B4,"txt"), "") but I prefer this one: =IF(A4<"",sheet1!A4&sheet2!B4&"txt","") -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE text formula | Excel Worksheet Functions | |||
| I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| CONCATENATE formula | Excel Discussion (Misc queries) | |||
| Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions | |||
Linear Mode
