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.