Conditional formatting

[Closed]
Report
Posts
2
Registration date
Tuesday August 1, 2017
Status
Member
Last seen
August 1, 2017
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
Hello,
If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good". But if I have in cell D3 a value of "3" and in cell F3 a value of "1" then I want cell G3 to say "Excellent". And if I have in cell D3 a value of 4 and in cell F3 a value of "0" then I want cell G3 to say "Not bad"
Please help

2 replies

Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
KingFloyd, Good morning.

What you need does not refer to conditional formatting.
Conditional formatting serves to change aesthetic aspects.

It can be solved simply with a sequence of the nested IF functions.

Try to use:

G3 --> =IF(AND(D3=2, F3=1), "Good",IF(AND(D3=3, F3=1), "Excellent", IF(AND(D4=2, F3=0), "Not bad", "")))

Was that what you wanted?
I hope I have helped you.
Posts
2
Registration date
Tuesday August 1, 2017
Status
Member
Last seen
August 1, 2017

I entered the formula and it is returning a "TRUE" value, not " good, or excellent or not bad. Please let me know what I'm doing wrong
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
KingFloyd,

Please, take a look at this little example I did for you.

https://www.sendspace.com/file/f95ikj

Tell us if it worked as you wanted.