Conditional formatting

KingFloyd 2 Posts Tuesday August 1, 2017Registration date August 1, 2017 Last seen - Aug 1, 2017 at 04:03 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- 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
See more 

Your reply

3 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Aug 1, 2017 at 07:47 AM
0
Thank you
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 2 Posts Tuesday August 1, 2017Registration date August 1, 2017 Last seen - 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
Respond to Mazzaropi
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Aug 1, 2017 at 08:21 AM
0
Thank you
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.
Respond to Mazzaropi