Conditional formatting

Closed
KingFloyd Posts 2 Registration date Tuesday August 1, 2017 Status Member Last seen August 1, 2017 - Aug 1, 2017 at 04:03 AM
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 - Aug 1, 2017 at 08:21 AM
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

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Aug 1, 2017 at 07:47 AM
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.
0
KingFloyd Posts 2 Registration date Tuesday August 1, 2017 Status Member Last seen August 1, 2017
Aug 1, 2017 at 08:00 AM
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
0
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Aug 1, 2017 at 08:21 AM
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.
0