Conditional Formatting with 3 formats

[Bluecalc]

I need to make my table reflect this info:
1 column has the percentages and the other one is blank, can someone help? please

Segment 1 = 0-80%
Segment 2 = 81%-100%
Segment 3 = >100%


So the blank one should show which segment each percentage falls into.

 

[Bluecalc]

*3 conditions

 

[McGuilliam]

Not sure if you mean it should return the segment name or if you need something else, but if it is the names you want this can be done with a IF-function like this:

=IF(A1<=80%;"Segment 1";IF(A1<100%;"Segment 2"; "Segment 3"))

 

[Bluecalc]

I got this message

 

[Bluecalc]

Not sure if you mean it should return the segment name or if you need something else, but if it is the names you want this can be done with a IF-function like this:

=IF(A1<=80%;"Segment 1";IF(A1<100%;"Segment 2"; "Segment 3"))

I got this message

 

[Bluecalc]

oh thank you!

=IF(J7<=80%,"Segment 1",IF(J7<100%,"Segment 2",IF(J7>=100%,"Segment 3")))

that's the one! :D

Not sure if you mean it should return the segment name or if you need something else, but if it is the names you want this can be done with a IF-function like this:

=IF(A1<=80%;"Segment 1";IF(A1<100%;"Segment 2"; "Segment 3"))

 

[Peter_SSs]

=IF(J7<=80%,"Segment 1",IF(J7<100%,"Segment 2",IF(J7>=100%,"Segment 3")))

that's the one! :D

That doesn't seem to be to do with Conditional Formatting per your title thread, but this should produce the same results as the formula you have given

="Segment "&MATCH(J7,{0,0.800001,1})