Carriage Return was new to me and I am very happy to know it now.
@bcti-bcti
2 ай бұрын
@@TheMarkGross Very glad to know there was something new in there for you. Thanks for watching.
@maciejkopczynski55
2 ай бұрын
Great topic - as always! If we had more complex logic around the formatting K, M, B… we could also consider doing a lookup table for our custom formats and simply do an approximate lookup. I’m waiting for more upcoming BCT’s goodies.
@bcti-bcti
2 ай бұрын
That's why we love Excel so much... there's always more than one way to solve a problem (or improve upon an existing solution.) Thanks for your input and viewership.
@IvanCortinas_ES
2 ай бұрын
Great tutorial. That's very useful. Thank you for sharing.
@bcti-bcti
2 ай бұрын
@@IvanCortinas_ES Glad to know you could use the info. Thanks for watching.
@arnyanderson4955
2 ай бұрын
Really amazing and love the way you go through
@bcti-bcti
2 ай бұрын
@@arnyanderson4955 Thanks! I think I know what you were saying. The text dropped off.
@chrism9037
2 ай бұрын
Very informative, thank you!
@kebincui
2 ай бұрын
Excellent contents like all your other videos. Thanks 👍👍❤🌹
@bcti-bcti
2 ай бұрын
@@kebincui Thank YOU!!!
@Luciano_mp
2 ай бұрын
Great tips! Thank you.👍
@bcti-bcti
2 ай бұрын
@@Luciano_mp thank you for taking the time to watch.
@excel_along_the_way
2 ай бұрын
Very helpfull, thank you.
@bcti-bcti
2 ай бұрын
@@excel_along_the_way You are very welcome. Thanks for watching.
@7213261
2 ай бұрын
Thanks!
@bcti-bcti
2 ай бұрын
@@7213261 you are quite welcome. Thanks for watching
@KO1967
2 ай бұрын
Good content as it relates to the main topic but I'd like to introduce you to the IFS function in lieu of nested IF functions.
@bcti-bcti
2 ай бұрын
Thanks for the support. I'm familiar with the IFS function, but this was a way to introduce viewers to the technique of formatting longer, more complicated formulas for greater readability. But I agree with you, in the Real World, the IFS would be a better choice. Thanks for watching.
@willbedeadsoon
2 ай бұрын
I think that you don't need that third IF in combined formula, just text format string, because if first (>1000000) and second (between 100k and. 1000000) conditions are false you get
@bcti-bcti
2 ай бұрын
If you look closely at the bottom of your screen when I was composing those formulas, I put that in as a visual note advising of just such a tactic. Great idea. Thanks for watching.
@tinhoyhu
2 ай бұрын
Nice. Didn't know about the comma after period trick. If the All column was named Numbers, could've also used an Index Match. I see that Excel also has Valuetotext. Is there any difference between that and Text?
@bcti-bcti
2 ай бұрын
Where VALUETOTEXT converts anything that looks like a number to text, TEXT is simply used to reformat (i.e., change the way numbers are presented.)
@pierre-yves_david
2 ай бұрын
Interesting, as usual, many thanks: tricky the "," at the end of data format to divide by 1,000. Too sad Excel conditional formatting does allow dynamic ranges only for tables and not spilling ranges (it is possible to write G1# but it is converted to a static range and if you add new lines to the spill range, the conditional formatting range does not change). Why not using IFS() instead of IF()? Formula would be more readable.
@bcti-bcti
2 ай бұрын
I agree. I with Conditional Formatting would get the ability to deal with spill ranges. Perhaps in the future (one can only hope.)
@pierre-yves_david
2 ай бұрын
A suggestion: using TEXT(B2, IFS(condition1, format1, condition 2, format2, condition3, format3)) seems more readable than nested if?
@bcti-bcti
2 ай бұрын
@@pierre-yves_david I agree. That’s what’s great about Excel: there’s always more than one way to solve a problem.
@willbedeadsoon
2 ай бұрын
I think that you don't need that third IF in combined formula, just text format string, because if first (>1000000) and second (between 100k and. 1000000) conditions are false you get
@bcti-bcti
2 ай бұрын
If you look closely at the bottom of your screen when I was composing those formulas, I put that in as a visual note advising of just such a tactic. Great idea. Thanks for watching.
@willbedeadsoon
2 ай бұрын
I think that you don't need that third IF in combined formula, just text format string, because if first (>1000000) and second (between 100k and. 1000000) conditions are false you get
@bcti-bcti
2 ай бұрын
If you look closely at the bottom of your screen when I was composing those formulas, I put that in as a visual note advising of just such a tactic. Great idea. Thanks for watching.
Пікірлер: 33