SOLVED

Copper Contributor

Hi, I’m looking for help please on what I believe should be a COUNTIFS formula. I’ve gone round in circles trying to work this one out but am losing the will….

I am currently using a COUNTIF formula with one input cell, yielding one of two text-string results. Going forward I need to introduce a second input cell, the results of the combination of both cells are to yield one of four text-string results.

The two input cells, for simplicity will be A1 and B1, which are to yield the text string in C1.

The result is to be a text string:

1. If A1 and B1 are both >0:  “Contracted” and,
2. If A1=0, and B1>0:  “Price Missing” and,
3. If A1>0, and B1<1:  “Not Signed” and,
4. If A1 and B1 are both <1: “Not Contracted”

Help would be very much appreciated. Many thanks in advance, Martin

2 Replies
best response confirmed by Tolley123 (Copper Contributor)
Solution

# Re: COUNTIFS Wizard Required Please

=IF(A1>0, IF(B1>0, "Contracted", "Not Signed"), IF(B1>0, "Price Missing", "Not Contracted"))

# Re: COUNTIFS Wizard Required Please

Hans, that is brilliant. Thank you so very much. Best regards.
1 best response

Accepted Solutions
best response confirmed by Tolley123 (Copper Contributor)
Solution

# Re: COUNTIFS Wizard Required Please

=IF(A1>0, IF(B1>0, "Contracted", "Not Signed"), IF(B1>0, "Price Missing", "Not Contracted"))