Question description:
This user has given permission to use the problem statement for this
blog.
i have a scale rating from 1-10 i wana look for a fourmila to convert it to words .
if 1-2 defintly wont recommend 3-4 wont reccoment 4-5 i might and might not and like this
Solved by G. S. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
10/12/2017 - 07:05
hey
Excelchat Expert
10/12/2017 - 07:05
Hi, M sudhans
User
10/12/2017 - 07:05
hey how are you
Excelchat Expert
10/12/2017 - 07:05
May i know your name?
User
10/12/2017 - 07:05
i have a qustion
User
10/12/2017 - 07:05
now am doing a servy and analysing it
User
10/12/2017 - 07:05
so what i have is like the following
Excelchat Expert
10/12/2017 - 07:05
m good too and the same with you
Excelchat Expert
10/12/2017 - 07:06
okay will take your query
User
10/12/2017 - 07:06
if i wana convert the numbers to words
Excelchat Expert
10/12/2017 - 07:06
So your randomly filling the cell
Excelchat Expert
10/12/2017 - 07:07
and this number you want to convert to text?
User
10/12/2017 - 07:07
like if 1-2 i wana write defintly not reccomend
User
10/12/2017 - 07:07
and from 2-3 wont reccomend
User
10/12/2017 - 07:07
and goes on
User
10/12/2017 - 07:07
u got me ?
Excelchat Expert
10/12/2017 - 07:08
okay can you define me the ranges and your condition?
User
10/12/2017 - 07:09
1-2 ( defintly would not )3-4 ( probbly would not )5-6 ( might ot might not) 7-8( problly would ) 9-10 ( defintlly would )
User
10/12/2017 - 07:09
so what fucntion should i use ?
Excelchat Expert
10/12/2017 - 07:09
you can use conditional formating
User
10/12/2017 - 07:10
can you give me the fourmila
Excelchat Expert
10/12/2017 - 07:12
Just give a while
Excelchat Expert
10/12/2017 - 07:12
i will be sending you the sheet
Excelchat Expert
10/12/2017 - 07:12
with formula
Excelchat Expert
10/12/2017 - 07:12
will that be good?
User
10/12/2017 - 07:13
sure or write it here if you may
User
10/12/2017 - 07:13
and my qustion is after getting the data i wana do it to a visualise chart is it better with a pie chart or a bar chart ?
Excelchat Expert
10/12/2017 - 07:13
ya sure will write here
Excelchat Expert
10/12/2017 - 07:14
if your data is less than 6 then pie would be better else go for bar chart!
User
10/12/2017 - 07:14
yea it gona be 5 only
Excelchat Expert
10/12/2017 - 07:15
Pie one will be good
User
10/12/2017 - 07:15
the ones i wrote from 1-2 ( defintly wont reccoment
User
10/12/2017 - 07:15
i have 700 people that took that data so i wana do the precentage of the scaling
Excelchat Expert
10/12/2017 - 07:16
okay just let me complete the formula will move forward to your queries
User
10/12/2017 - 07:17
ok
Excelchat Expert
10/12/2017 - 07:21
for 3-4 what would you get
Excelchat Expert
10/12/2017 - 07:22
not recommended?
User
10/12/2017 - 07:22
probably would not
User
10/12/2017 - 07:22
or wtv you reccoment
User
10/12/2017 - 07:22
reccomend
User
10/12/2017 - 07:30
u there ?
Excelchat Expert
10/12/2017 - 07:30
\Yes m here
Excelchat Expert
10/12/2017 - 07:30
just a while
Excelchat Expert
10/12/2017 - 07:31
m completingit
User
10/12/2017 - 07:31
ok
User
10/12/2017 - 07:31
tyt
Excelchat Expert
10/12/2017 - 07:31
Sure
Excelchat Expert
10/12/2017 - 07:32
Thanks for your patience
Excelchat Expert
10/12/2017 - 07:36
Just a minute more
User
10/12/2017 - 07:40
ok
Excelchat Expert
10/12/2017 - 07:42
Hey
Excelchat Expert
10/12/2017 - 07:42
i Designed the formula for you
Excelchat Expert
10/12/2017 - 07:42
Are you there?
User
10/12/2017 - 07:42
show me please
User
10/12/2017 - 07:42
yep
Excelchat Expert
10/12/2017 - 07:43
Is that good?
User
10/12/2017 - 07:43
yep
User
10/12/2017 - 07:43
=IF(OR(A7=1,A7=2),"defintly would not",IF(OR(A7=3,A7=4),"probbly would not",IF(OR(A7=5,A7=6),"might or might not",IF(OR(A7=7,A7=8),"probably would",IF(OR(A7=9,A7=10),"definitelly would","Not Mentiond")))))
Excelchat Expert
10/12/2017 - 07:43
Please provide a valuable meeting
User
10/12/2017 - 07:43
this is it ?
User
10/12/2017 - 07:43
wait let me try it i have other qustions for you
Excelchat Expert
10/12/2017 - 07:43
Sure
Excelchat Expert
10/12/2017 - 07:44
Please do provide a valuable rating after our chat
Excelchat Expert
10/12/2017 - 07:44
yes m waiting
User
10/12/2017 - 07:44
wow it workded
User
10/12/2017 - 07:44
amazing
User
10/12/2017 - 07:45
so your telling me i use a pie chart for that ?
Excelchat Expert
10/12/2017 - 07:45
M happy to hear that
Excelchat Expert
10/12/2017 - 07:46
May i know your name please?
User
10/12/2017 - 07:46
abodi
User
10/12/2017 - 07:47
i have another qustion
User
10/12/2017 - 07:47
when using the box plot
Excelchat Expert
10/12/2017 - 07:47
sure abodi please go ahead
User
10/12/2017 - 07:47
i have an average of sleeping/h/night
User
10/12/2017 - 07:47
i have alot of number almost 400 entered there sleeping per night
User
10/12/2017 - 07:47
i wana turn that to a something to see
User
10/12/2017 - 07:47
do you reccomend a box plot ?
Excelchat Expert
10/12/2017 - 07:47
okay
Excelchat Expert
10/12/2017 - 07:48
can you share me your spreadsheet?
User
10/12/2017 - 07:48
i dont have it on this pc
User
10/12/2017 - 07:49
so now if i wana do it on something
User
10/12/2017 - 07:49
a pie chart
User
10/12/2017 - 07:49
bar
User
10/12/2017 - 07:49
box plot
User
10/12/2017 - 07:49
which do u reccoment
Excelchat Expert
10/12/2017 - 07:49
okay box plot in the sence you are saying about the hierachy chart?
User
10/12/2017 - 07:50
so i can say the max was 11 h min was 6 q1 = this q2 =this range is this
User
10/12/2017 - 07:50
do u reccomend box plot
User
10/12/2017 - 07:51
or anything else
Excelchat Expert
10/12/2017 - 07:51
and if number almost 400 entered : is there any grouping among those
User
10/12/2017 - 07:51
nope
User
10/12/2017 - 07:51
no grouping
Excelchat Expert
10/12/2017 - 07:51
okay q1 and q2
User
10/12/2017 - 07:51
of all participitn
User
10/12/2017 - 07:51
i have 400 and all wrote there there sleeping average per night
Excelchat Expert
10/12/2017 - 07:51
are these separate groups among the 400
User
10/12/2017 - 07:51
well
User
10/12/2017 - 07:52
the people that finsihed the servay were 752 only 400 answwered this qustion
Excelchat Expert
10/12/2017 - 07:52
okay 400 and all gave their sleeping average
Excelchat Expert
10/12/2017 - 07:53
so for this bar chart would be great option
Excelchat Expert
10/12/2017 - 07:53
as you can figure out the trend easily
Excelchat Expert
10/12/2017 - 07:54
and for better visuality u can try for scatter or bubble chart!
User
10/12/2017 - 07:54
aha
User
10/12/2017 - 07:54
nice
User
10/12/2017 - 07:54
let me try wait
Excelchat Expert
10/12/2017 - 07:54
Yes sure
Excelchat Expert
10/12/2017 - 07:55
If any time chart gets disconnected please mail me on : sekhar.google444@outlook.in
Excelchat Expert
10/12/2017 - 07:56
Are you there Abodi?
Excelchat Expert
10/12/2017 - 07:58
Hey, Are you there?
Excelchat Expert
10/12/2017 - 07:59
Can i have a reply, please?
Excelchat Expert
10/12/2017 - 08:01
are you there?
Excelchat Expert
10/12/2017 - 08:04
Hey are you there?
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.