| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use multiple functions in single formula
I am attempting to generate a formula that states if the data in cell A1=A2,
then merge the data in cells C1&C2 separated by a comma Cannot combine both =IF and =CONCATENATE in the same formula -- Andrea54 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use multiple functions in single formula
hi
try this =IF(A1=A2,C1&", "&C2,0) regards FSt1 "Andrea54" wrote: I am attempting to generate a formula that states if the data in cell A1=A2, then merge the data in cells C1&C2 separated by a comma Cannot combine both =IF and =CONCATENATE in the same formula -- Andrea54 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use multiple functions in single formula
Worked like a charm, thank-you very much!
-- Andrea54 "FSt1" wrote: hi try this =IF(A1=A2,C1&", "&C2,0) regards FSt1 "Andrea54" wrote: I am attempting to generate a formula that states if the data in cell A1=A2, then merge the data in cells C1&C2 separated by a comma Cannot combine both =IF and =CONCATENATE in the same formula -- Andrea54 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use multiple functions in single formula
=IF(A1=A2,C1&","&C2,"")
You can have two functions, you just use one =. -- __________________________________ HTH Bob "Andrea54" wrote in message ... I am attempting to generate a formula that states if the data in cell A1=A2, then merge the data in cells C1&C2 separated by a comma Cannot combine both =IF and =CONCATENATE in the same formula -- Andrea54 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple functions in a single cell | Excel Worksheet Functions | |||
| Can you use multiple operators in a single formula? | Excel Worksheet Functions | |||
| How can I rank values in multiple subsets using a single formula? | Excel Discussion (Misc queries) | |||
| Ranking values in multiple subsets using one single formula | Excel Discussion (Misc queries) | |||
| Multiple lookup in a single formula .. | Excel Worksheet Functions | |||
Hybrid Mode
