求助：编写满足三类条件的Excel单元格输出公式

Here's a clean, straightforward formula that meets all your requirements. Pop this into cell A4:

=IF(A1="", "", IF(A1="Leader", A2&"(Leader)", A2))

Let me break down how it works, step by step:

• First condition check: The outer IF checks if cell A1 is empty. If it is, A4 returns a blank value ("").
• Second condition check: If A1 isn't empty, we move to the inner IF:
  • If A1 exactly matches "Leader", it concatenates the full name from A2 with "(Leader)" using the & operator.
  • For any other non-empty value in A1 (like "Member"), it simply returns the full name from A2 as-is.

This formula handles all your specified cases clearly, and it's easy to adjust later if you need to add more role types.

内容的提问来源于stack exchange，提问作者Wayne