多条件IF语句组合求助：基于单元格空/非空返回不同结果

Got it, let’s break down how to combine your two conditional checks into one clean, working formula. First, let’s recap the rules we need to cover:

• When cell I49 is blank, return "RCVD"
• When I49 isn’t blank, apply your original logic:
  • If K49 or F49 is blank, return an empty string
  • If both K49 and F49 are filled, and F49 equals 500, return "REQUEST"
  • Otherwise, return an empty string

Since the "RCVD" trigger (I49 being blank) is a clear top-level condition, we’ll build the combined formula around that first check. Here’s the final formula:

=IF(ISBLANK(I49),"RCVD",IF(OR(ISBLANK(K49),ISBLANK(F49)),"",IF(F49=500,"REQUEST","")))

How this works step-by-step: #

1. First check: We start with ISBLANK(I49) — if this is true, we immediately return "RCVD" and stop processing any further conditions.
2. Second tier (I49 is not blank): We jump into your original logic:
   • We use OR(ISBLANK(K49),ISBLANK(F49)) to check if either of those cells is empty. If yes, we return an empty string.
   • If both K49 and F49 are filled, we then check if F49 equals 500. If that’s true, we return "REQUEST"; if not, we return an empty string.

Quick edge case note: #

If you ever need "REQUEST" to take priority over "RCVD" (for example, if I49 is blank but K49/F49 meet the REQUEST criteria), you could reverse the order of the top-level checks. But based on your original separate formulas, prioritizing "RCVD" when I49 is blank aligns with what you described.

内容的提问来源于stack exchange，提问作者T. Iund