Share via

IF FUNCTION WITH MULTIPLE CELL, MULTIPLE CONDITION AND ISBLANK

Anonymous
2023-11-08T07:47:44+00:00

Hello. I am trying to return 3 different condition for multiple cell. Example, if cell A1 or B1 less than 5, return in C1 "X", if both of them more than 5, return in C1 "OK". But if the cell is blank, return in C1 also blank. So far I only manage to write until "X" and "OK" part. This is how I wrote it, =IF(OR(A1<5,B1<5),"X","OK". I try to use ISBLANK function but I couldn't find where to put ISBLANK in the function. I also try use IFS function but it turn out error.

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2023-11-08T07:52:55+00:00

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",IF(OR(A1<5,B1<5),"X",IF(AND(A1>=5,B1>=5),"OK","")))

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-08T08:30:06+00:00

    Thank you so much. I appreciate your help.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-11-08T08:36:31+00:00

    You are welcome. You may also give feedback on it. Thank you:)

    Was this answer helpful?

    0 comments