Report

Conditional formatting

Ask a question KingFloyd 2Posts Tuesday August 1, 2017Registration date August 1, 2017 Last seen - Last answered on Aug 1, 2017 at 08:21 AM by Mazzaropi
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 
Helpful
+0
plus moins
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 2Posts 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
Reply
Leave a comment
Helpful
+0
plus moins
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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!