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