CODEWITHSUNDEEP
excel
GGB
GGB

Reputation: 11

Excel If 2 cells match third returns specific text

This seems like a simple request but I am struggling to find a simple answer. I have 3 cells, let’s call them A1, B1, C1. I would like a formula to address the following: If the numerical values in A1 and B1 match then C1 needs to show the text “complete” If the numbers in A1 and B1 do not match then C1 to show text “Partial” If there is nothing in A1 and B1 then C1 to show text “Incomplete”. I hope this is a simple enough explanation. Help appreciated.

Upvotes: 1

Views: 490

Answers (3)

Gowtham Shiva
Gowtham Shiva

Reputation: 3875

May be you can try this in cell C1,

=IF(A1<>B1,"Partial",IF(A1="","InComplete","Complete"))

Upvotes: 0

Jeremy Kahan
Jeremy Kahan

Reputation: 3826

=IF(A1&B1="","incomplete",IF(A1=B1,"complete","partial"))

in the other cell will do it

Upvotes: 0

Otsuki Takaya
Otsuki Takaya

Reputation: 172

If you use A1 B1 C1 cell, C1 function is =IF(AND(A1="",B1=""),"Incomplete",IF(A1=B1,"complete","Partial"))

Upvotes: 1

Related Questions