Excel - IF Function Problem - Expert Solution

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

Wanted the cell to indicate if number is +/- from desired total
Solved by D. D. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/05/2018 - 08:04
Excelchat Expert 29/05/2018 - 08:05
Welcome to excelchat.
Excelchat Expert 29/05/2018 - 08:05
We are happy to have you today with us.
User 29/05/2018 - 08:05
Excelchat Expert 29/05/2018 - 08:06
Please tell me details, I want to be sure that I understand the problem clearly.
User 29/05/2018 - 08:06
would like the total (for expamle D9) to display +/1 a specific total
Excelchat Expert 29/05/2018 - 08:08
I'm sorry, I'm not sure what does that mean. I understand that you have tried your best. My apologies but I need more information.
User 29/05/2018 - 08:08
if the total is three would like the number to be green at three and red for any other number
Excelchat Expert 29/05/2018 - 08:08
Alright, it seems conditional formatting problem.
User 29/05/2018 - 08:09
I want to know if the total is at the correct value
Excelchat Expert 29/05/2018 - 08:09
So, may I know which cell indicates the total?
User 29/05/2018 - 08:10
D15 - D21 would be the ones i am looking to indicate if the value has been reached (green) or if its over/under (red)
Excelchat Expert 29/05/2018 - 08:11
Okay. Understood.
Excelchat Expert 29/05/2018 - 08:11
What is the number that indicates a value has been reached?
Excelchat Expert 29/05/2018 - 08:11
Is it 3?
User 29/05/2018 - 08:12
each day of the week would have a different total. Monday - Friday each day I need 3 QC and 3 EC and one CH
User 29/05/2018 - 08:13
Sat and sunday I need 2 PNO 2 CH and 2 FZ
Excelchat Expert 29/05/2018 - 08:14
Is there anything else?
User 29/05/2018 - 08:14
no the others are one off events.
Excelchat Expert 29/05/2018 - 08:15
Thank you, do you want me to show how to do it or you just want me to do the task?
User 29/05/2018 - 08:15
Sat CH and PNO are the same people which means the cell is CH/PNO
User 29/05/2018 - 08:16
you can just do it and i will work with the formula
Excelchat Expert 29/05/2018 - 08:16
Thank you.
Excelchat Expert 29/05/2018 - 08:22
Okay, I have formatted accordingly, please check.
User 29/05/2018 - 08:24
on saturday is CH/PNO treated as to separate inputs. Both CH and PNO not CH/PNO
Excelchat Expert 29/05/2018 - 08:25
I'm sorry?
Excelchat Expert 29/05/2018 - 08:26
My apologies, I think you have asked to format the cells based on value reached.
Excelchat Expert 29/05/2018 - 08:27
I can't relate the statement "on saturday is CH/PNO treated as to separate inputs. Both CH and PNO not CH/PNO" to the formatting problem
Excelchat Expert 29/05/2018 - 08:31
Please let me know if you were looking for something else.
User 29/05/2018 - 08:33
E11 CH/PNO does this count in totals?
Excelchat Expert 29/05/2018 - 08:35
I'm sorry, if you also want me to count the words in the range above, please let me know. Otherwise I don't know what you mean.
User 29/05/2018 - 08:36
ok thanks for your help

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc