CODEWITHSUNDEEP
excelvba
Rae
Rae

Reputation: 25

How to simplify this "if" condition?

its me again with another probably trivial question...

is there any way how to simplify (loop?) this condition?

The porpose of this is to make my X-axis label more clear to read rather than how it currently looks

example

My source data are in following format starting with 2015/Q4,2016/Q1,2016/Q2...up to most recent quater

"=IF(RC[-1]=""2015/Q4"",""2015" & Chr(10) & "Q4""",IF(RC[-1]=""2016/Q1"",""2016" & Chr(10) & "Q1"" ... and so on

Upvotes: 0

Views: 55

Answers (2)

Dominique
Dominique

Reputation: 17565

What about this:

=SUBSTITUTE(I3,"/",CHAR(10))

Bigben proposed the function, but not the replacement character.

Upvotes: 1

Notus_Panda
Notus_Panda

Reputation: 2810

You mean something like:

"=LEFT(RC[-1],4) & Chr(10) & RIGHT(RC[-1],2)"

Upvotes: 0

Related Questions