表格自动同步：当COL_B为NO时将COL_A值复制到COL_C

Ah, I’ve been there—forgetting the third argument in the IF function leads to those pesky FALSE values when you expect a blank. Your original formula only defines what happens when COL_B is "NO", but doesn’t specify the fallback case for when it’s "YES".

Here’s the simple fix you need:

=IF(COL_B="NO", COL_A, "")

How this works: #

• Condition: COL_B="NO" checks if the value in COL_B matches "NO"
• True result: Returns the corresponding value from COL_A (exactly what you want)
• False result: Returns an empty string (""), which makes the cell appear completely blank instead of displaying FALSE

For new rows, you have two easy options:

• Drag the formula down to the new cells—most spreadsheets will auto-adjust the cell references to match the row
• Use a dynamic array formula (supported in Google Sheets, Excel 365, etc.) to apply this logic to the entire column automatically. For example, in Google Sheets:

  =ARRAYFORMULA(IF(COL_B:COL_B="NO", COL_A:COL_A, ""))
  

This array formula will automatically update whenever you add new rows with data in COL_B, so you don’t have to manually copy the formula each time.

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