Excel - IF Function Problem - Expert Solution

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

I need a formula that if the sum of a range is equal to a number in a bank say in the region of 61 - 80 a specific text is instead shown say "Client A", but if the sum fell in the region of 51 - 60 that a different text would show, for instance "client b", is there such a way or how would you go about it? I've used if sum's before but never to highlight a range. Thank you, Alastair.
Solved by V. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/03/2018 - 12:32
Welcome to excel got it pro.
Excelchat Expert 06/03/2018 - 12:32
I'm here to help you today.
User 06/03/2018 - 12:32
HI, hope you can help, does the query make sense?
Excelchat Expert 06/03/2018 - 12:32
Yes it does.
Excelchat Expert 06/03/2018 - 12:33
You want to show a text rather than the sum value, right?
Excelchat Expert 06/03/2018 - 12:33
If you kindly show me some sample data, I would be able to show you how to do it.
User 06/03/2018 - 12:33
yes depending on the result of the sum I need to display 4 categorys
User 06/03/2018 - 12:33
3 in a band then the final one < everything elses
Excelchat Expert 06/03/2018 - 12:34
Okay, but do construct a formula, I need to know the 4 categories and also the data if possible.
Excelchat Expert 06/03/2018 - 12:35
If you can't show me, I understand and I would show an example with demo data.
User 06/03/2018 - 12:35
ok I can't forward the s/s but can mock one up on the table to the right if that's ok?
Excelchat Expert 06/03/2018 - 12:35
That would be very helpful.
User 06/03/2018 - 12:37
So there are three criteria which depending on the selection will give a different weighted score
User 06/03/2018 - 12:37
this will give a score out of 120
User 06/03/2018 - 12:38
bandings are on the right and I could use it either changing the text of the total to read which client
User 06/03/2018 - 12:38
or another cell below showing which client while still leaving the total number, does that make sense?
Excelchat Expert 06/03/2018 - 12:38
Okay, gimme a few minutes.
User 06/03/2018 - 12:39
great, thank you
Excelchat Expert 06/03/2018 - 12:46
Please look at C8.
Excelchat Expert 06/03/2018 - 12:47
This would also require to format the Bandings table a slightly differently as shown in column I and J.
User 06/03/2018 - 12:48
Ok thank you that appears to make sense, is it possible to copy the s/s or save a copy of the fomula?
User 06/03/2018 - 12:49
That's great, thank you for the help
Excelchat Expert 06/03/2018 - 12:49
Yes, you can download the file
Excelchat Expert 06/03/2018 - 12:49
by clicking on the file menu on the top right corner.
Excelchat Expert 06/03/2018 - 12:50
[Uploaded an Excel file]
Excelchat Expert 06/03/2018 - 12:51
here is a copy of the file.
Excelchat Expert 06/03/2018 - 12:51
The session will end now.
Excelchat Expert 06/03/2018 - 12:51
You will be asked to rate me once it end.
Excelchat Expert 06/03/2018 - 12:51
A five star would be much appreciated.
Excelchat Expert 06/03/2018 - 12:51
Thanks and have a great day.

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