# Excel - IF Function Problem - Expert Solution

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

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.