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
please
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
please check
User
06/02/2018 - 03:45
THANK YOU
User
06/02/2018 - 03:45
!!!
Excelchat Expert
06/02/2018 - 03:45
please help me by rating 5 star
User
06/02/2018 - 03:45
wait
User
06/02/2018 - 03:45
so what about
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
please*
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
please check
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
please help me by rating 5 star
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
please close the session
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
please check
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.
