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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.

Similar discussions