**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.*