# Excel - IF Function Problem - Expert Solution

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

I have a question on the If formula with multiple characters.
Solved by G. D. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/02/2018 - 03:41
hi
Excelchat Expert 06/02/2018 - 03:42
welcome at got it pro
User 06/02/2018 - 03:42
hello
User 06/02/2018 - 03:42
I have a quick question
Excelchat Expert 06/02/2018 - 03:42
User 06/02/2018 - 03:42
i am going to show you what i need help with
Excelchat Expert 06/02/2018 - 03:42
yes go on
User 06/02/2018 - 03:43
if they all say "increase"
User 06/02/2018 - 03:43
i want it to only show "Increase"
User 06/02/2018 - 03:43
if they have increase, increase, decrease, then i want it to type in Increase / (Decrease)
Excelchat Expert 06/02/2018 - 03:43
ok out of 3?
User 06/02/2018 - 03:43
yes
User 06/02/2018 - 03:43
as an example
Excelchat Expert 06/02/2018 - 03:43
in which cell?
User 06/02/2018 - 03:43
b5
User 06/02/2018 - 03:44
so if the following 3, has all increase...it should formulate to just "Increase"
User 06/02/2018 - 03:44
if it has increase and decrease, it should formulate to Increase / (Decrease)
User 06/02/2018 - 03:44
and if it has decrease, it should formulate to "Decrease"
Excelchat Expert 06/02/2018 - 03:45
User 06/02/2018 - 03:45
THANK YOU
User 06/02/2018 - 03:45
!!!
Excelchat Expert 06/02/2018 - 03:45
User 06/02/2018 - 03:45
wait
User 06/02/2018 - 03:45
User 06/02/2018 - 03:45
if it has increase, increase, decrease
User 06/02/2018 - 03:45
it should say
User 06/02/2018 - 03:46
can you fix my first formula
Excelchat Expert 06/02/2018 - 03:46
ok
Excelchat Expert 06/02/2018 - 03:46
check pleaes
Excelchat Expert 06/02/2018 - 03:46
User 06/02/2018 - 03:46
no it should be "Increase / (Decrease)
User 06/02/2018 - 03:46
if it has both
Excelchat Expert 06/02/2018 - 03:47
if you change the value from A1,a2 and a3 then the answe will be displayed in cell B1
Excelchat Expert 06/02/2018 - 03:48
both mean?
User 06/02/2018 - 03:48
this is what i mean
User 06/02/2018 - 03:48
cell B9 thats what it should formulate
User 06/02/2018 - 03:48
in this case
Excelchat Expert 06/02/2018 - 03:49
ok if increase and decrease both available then it should shows both?
User 06/02/2018 - 03:49
it should formulate as "Increase / (Decrease)"
User 06/02/2018 - 03:49
yessss
Excelchat Expert 06/02/2018 - 03:49
ok wait
User 06/02/2018 - 03:49
if it has both
User 06/02/2018 - 03:49
thanks
Excelchat Expert 06/02/2018 - 03:52
User 06/02/2018 - 03:53
THANK YOU FOR VERY MUCH
User 06/02/2018 - 03:53
this helps a lot!
User 06/02/2018 - 03:53
this drove me crazy haha
Excelchat Expert 06/02/2018 - 03:53
Excelchat Expert 06/02/2018 - 03:53
bye
User 06/02/2018 - 03:53
absolutely!
Excelchat Expert 06/02/2018 - 03:53
nice to meet you
User 06/02/2018 - 03:53
likewise
Excelchat Expert 06/02/2018 - 03:53
thanks for using got it pro
User 06/02/2018 - 03:53
is it always free until 20 min
Excelchat Expert 06/02/2018 - 03:54
i think so
Excelchat Expert 06/02/2018 - 03:54
you can check on website
Excelchat Expert 06/02/2018 - 03:55
User 06/02/2018 - 03:55
wait
User 06/02/2018 - 03:55
this formula doesnt work for decreasew
Excelchat Expert 06/02/2018 - 03:55
ok
User 06/02/2018 - 03:56
works for only increase
Excelchat Expert 06/02/2018 - 03:56
wait
User 06/02/2018 - 03:56
but what its only decrease
User 06/02/2018 - 03:56
ok
Excelchat Expert 06/02/2018 - 03:56
i think there is some error wait i am checking
User 06/02/2018 - 03:57
ok
Excelchat Expert 06/02/2018 - 03:57
Excelchat Expert 06/02/2018 - 03:58
done
Excelchat Expert 06/02/2018 - 03:58
now is ok?
User 06/02/2018 - 03:58
lemme check
Excelchat Expert 06/02/2018 - 03:58
sure
User 06/02/2018 - 04:00
wonderful thank you very much
User 06/02/2018 - 04:00
ending the session now

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.