Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi guys , I want to update an if condition so that if the value is less then 18 then it should say Great if more then 24 it should say too old and if anything else then it should say "wait Thanks
Solved by D. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/08/2017 - 08:36
Hi there!
User 06/08/2017 - 08:36
Hi
User 06/08/2017 - 08:37
this is great , never used this website before was just testing my luck and very excited to find such an amazing help
Excelchat Expert 06/08/2017 - 08:37
Great, glad to help you! :)
User 06/08/2017 - 08:37
like I might want to add an effect and color like conditional formating
User 06/08/2017 - 08:38
result is less then it should have red color and blinking and if greater then it should have green color and blinking
Excelchat Expert 06/08/2017 - 08:39
Sure! Due to our policy of 1 question per 20 minute session, I may have to ask you to re-post your question and use the description EXPERTJS
Excelchat Expert 06/08/2017 - 08:39
But for this IF statement condition, do you have a sample document or do you prefer we just demonstrate it from this spreadsheet?
User 06/08/2017 - 08:40
it's the same thing jus tsome conditional formating but if I have to then I'll do that ..
User 06/08/2017 - 08:42
like the c2 has value 24 , so the result of b2 should be like if c2 is > then 26 it should say Great and blinking green , and if its less then 18 it should say bad and blinking red and between it should say "do nothing" with black background
User 06/08/2017 - 08:43
is this clear ?
User 06/08/2017 - 08:44
are you there ?
Excelchat Expert 06/08/2017 - 08:44
Right. But blinking conditional formatting would require VBA coding.
Excelchat Expert 06/08/2017 - 08:45
Yes. I was working on the formula, could you please check if that is the output you desire
User 06/08/2017 - 08:45
hmm ok then just green background for greator then and red background for less then
User 06/08/2017 - 08:45
ok sure , very excited
User 06/08/2017 - 08:46
I need to apply that in an excel worksheet so I hope your solution will work over there
User 06/08/2017 - 08:46
old version ms excel 2003
Excelchat Expert 06/08/2017 - 08:46
Yes, it would be more complicated in VBA and cost more. It's north worth it if you ask me. But if that is the output you would like, then that would be fine.
Excelchat Expert 06/08/2017 - 08:46
Oh. Yes this is just a nested IF statement.
User 06/08/2017 - 08:46
ok cool
Excelchat Expert 06/08/2017 - 08:47
So what it does is it creates multiple conditions and if that condition is not met, it will proceed to the next condition in sequence.
User 06/08/2017 - 08:47
yes
Excelchat Expert 06/08/2017 - 08:47
If you see in the formula, you may just simply change the parameters or add another IF statement inside it.
Excelchat Expert 06/08/2017 - 08:48
Good to hear the formula works for you. If you still would like to proceed with the simple conditional formatting, please re-post your question and use the description EXPERTJS
User 06/08/2017 - 08:49
I don't see the formaloa
User 06/08/2017 - 08:49
where is it
Excelchat Expert 06/08/2017 - 08:50
One moment.
User 06/08/2017 - 08:50
actually I want the value to be in one cell
User 06/08/2017 - 08:50
like the output of b2 say is what we are calculating ...
User 06/08/2017 - 08:50
based on the value in c2
User 06/08/2017 - 08:51
c2 > 24 = To OLD Green Background
Excelchat Expert 06/08/2017 - 08:51
Yes, that is what it does on D2.
Excelchat Expert 06/08/2017 - 08:52
[Uploaded an Excel file]
Excelchat Expert 06/08/2017 - 08:52
Kindly check the attached.
User 06/08/2017 - 08:52
yes , but I want the formula to work in one cell
User 06/08/2017 - 08:53
ahh great I see it working
Excelchat Expert 06/08/2017 - 08:53
Does it work for you?
User 06/08/2017 - 08:53
ds
User 06/08/2017 - 08:54
can we have different backgrounds
Excelchat Expert 06/08/2017 - 08:54
I attached the file with the formula.
Excelchat Expert 06/08/2017 - 08:54
Yes we can, it's just a sample file so you'll get the how the formula works. :)
Excelchat Expert 06/08/2017 - 08:55
Session is about to end in a minute. You may end the session now if you want, and post the question about conditional formatting afterwards. :)
Excelchat Expert 06/08/2017 - 08:55
Glad to have helped you.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.