IF & IFS functions ruclips.net/video/hG5vKMb0Lpo/видео.html IF with Multiple Conditions ruclips.net/video/NM5-bAUP29U/видео.html IF functions you should never use ruclips.net/video/6cwZoKdZh94/видео.html
WHAT??? I struggled with this problem so many times and had to work my way around it. And the solution is TO WRITE NOTHING!? It's genius within its simplicity and I love it!
Another great video, learned something on this channel every time. Something to consider: in certain scenarios this setup may suppress valid errors and using ISERROR (or some other way to uncover issues) along with this configuration may be helpful. Thanks again!
adoro a elegância e simplicidade com que resolve situações bem complicadas. Por exemplo quando uma uma linha auxiliar ou 2 e transporta apenas a essência sem efeitos colaterais .Suas soluções sempre prezam pela máxima independência e nunca despreza o benefício do arrastar as formulas em colunas ou linhas. Nunca me canso de aprender como ser melhor seja em google sheets ou excel. Aguardo o dia em que abordar como usar as library do googlescript para Se posso exemplificar desenvolvi a função de dígito verificador na planilha A. Mas à frente tenho uma outra planilha B , e não posso usar a função sem enxertar o código na planilha B, em outras palavras queria usar a funcionalidade como um serviço. De qq forma tem minha sincera gratidão por me trazer de volta para as linhas de código.rs
This is brilliant, will replacing “” with blanks improve calculation speed? I own many sheets with lots and lots of formulas that can take a few seconds to calculate so could this improve the overall sheet? Especially when used in an array?
I have a sheet that imports data from 2 different sheets through import range formula. The data appears in A1:A10 from one sheet and B1:B:10 from the other. We want to be able to type in any field without affecting the formula on the first row, which is import range. Is there a way of doing that. We want to be able to write over cells that are left blank, but with a formula on top we can't. Is that even possible?
Awesome content, I missed your videos, somehow youtube stopped notifying me. Btw, where's the video "Learn Google Spreadsheets enviou o vídeo Google Sheets Pivot Table with KPI & Bar Graphs"? I'm really interested in that one.
Yea, it's been 6+ months since youtube has been trying to tank the channel. Less than 1% of subscribers get notifications. The odd thing is if I don't post any videos the channel gets more views, if I post new videos it starts tanking the channel. So at this point I have pretty much 0 motivation to post new content. It's stupid. KPI video will be posted at a later date.
@@ExcelGoogleSheets Oh man, keep doing your great work. On behalf of the people that watch your videos, I can say you do one of the most enlighted actions in the world: teaching. You can't imagine how positive you impact on people lives, you might be responsible for a lot of people being able to get promoted or hired on a job position. Keep going, for us!
@@Puner54 it's not clear the situation you describe, but as Teacher suggests you can try to create an IF statement and create your own ERROR i.e IF(ISBLANK(E4),IFERROR(1/0),SOMETHING)
I have one lookup sheet from which I get data for my master sheet. But some of the lookup value was not updated so I am getting the #NA error in my master sheet. So how can I add my new values from the master sheet to my lookup sheet automatically? Could you please help me with this? Thanks in advance
I have a problem with my IF function, its not returning the value if the result is false. I'm doing a google form with morning and afternoon time log for employees but I'm having a problem processing the data if the employee only log at afternoon.
@@ExcelGoogleSheets I have a problem: I have 3 spreadsheet files: 1. Master data file 2. the file contains the importrange Vlookup data from the first file, it works fine 3. file contains importrange Vlookup data from second file = value not shown What is the solution? Please help. Thank You
is tehere any way to find or replace " " with blank in excel. I tried to convert into blank cell instead of " " in excel, but it doesn't run. It shows "Not Blank"
I think you gonna have to use a macro. Something like this should work over the area selected. for each cell in selection if cell.value = "" then cell.clearcontents end if next cell
This fixes a HUGE immensely annoying problem when you use a script with appendRow on sheets that have an arrayformula!!!! The row gets appended after all "blank" rows.
I guess they would be undefined when you pass it to the function and then the function probably returns null. Impossible to tell without seeing the implementation of the function.
@@ExcelGoogleSheets just learned that =IF(1,,)="" returns TRUE, kind of weird, as you showed up those are different for counting. Thanks for the insight.
Good lesson! Unfortunately, this method does not always work, for example, with =REGEXREPLACE(A1;"[\W]*"; ) , returns a non-empty cell (=CELL("type";B1)) "= l" - text).
That has nothing to do with this method. REGEXREPLACE function will always return text. You can say =IF(REGEXREPLACE(A1;"[\W]*"; )="",,REGEXREPLACE(A1;"[\W]*"; ))
IF & IFS functions ruclips.net/video/hG5vKMb0Lpo/видео.html
IF with Multiple Conditions ruclips.net/video/NM5-bAUP29U/видео.html
IF functions you should never use ruclips.net/video/6cwZoKdZh94/видео.html
WHAT??? I struggled with this problem so many times and had to work my way around it. And the solution is TO WRITE NOTHING!? It's genius within its simplicity and I love it!
Due this kind of problem I choose define something like "ops", so I always can check it,rs, yes I´ve never tried to forget to write it! kkk
Another great video, learned something on this channel every time. Something to consider: in certain scenarios this setup may suppress valid errors and using ISERROR (or some other way to uncover issues) along with this configuration may be helpful. Thanks again!
It took me hours to find the answer for this problem and I finally found this video. It worked. Thank you so much.
Thank you. That has been bugging me for years and the solution was so simple. I always learn from you!
adoro a elegância e simplicidade com que resolve situações bem complicadas. Por exemplo quando uma uma linha auxiliar ou 2 e transporta apenas a essência sem efeitos colaterais .Suas soluções sempre prezam pela máxima independência e nunca despreza o benefício do arrastar as formulas em colunas ou linhas. Nunca me canso de aprender como ser melhor seja em google sheets ou excel.
Aguardo o dia em que abordar como usar as library do googlescript para Se posso exemplificar desenvolvi a função de dígito verificador na planilha A.
Mas à frente tenho uma outra planilha B , e não posso usar a função sem enxertar o código na planilha B, em outras palavras queria usar a funcionalidade como um serviço.
De qq forma tem minha sincera gratidão por me trazer de volta para as linhas de código.rs
Estava ansioso por seus vídeos esse ano. Uma boa dica para o verdadeiro vazio, muito obrigado por ensinar isto.
Excellent...Learn something new
This is brilliant, will replacing “” with blanks improve calculation speed? I own many sheets with lots and lots of formulas that can take a few seconds to calculate so could this improve the overall sheet? Especially when used in an array?
I don't think this will improve the speed.
@@ExcelGoogleSheets yes, but a string with no chars still waste more than zero bytes.rs
hi my name is sunil your videos are awesome. I watch your every video in dip. please make more videos for =regex
I have a sheet that imports data from 2 different sheets through import range formula. The data appears in A1:A10 from one sheet and B1:B:10 from the other. We want to be able to type in any field without affecting the formula on the first row, which is import range. Is there a way of doing that. We want to be able to write over cells that are left blank, but with a formula on top we can't. Is that even possible?
u r great👍👍👍👍👏👏👏
Thanks!!!!
I subscribed !!
Thank You!
Awesome content, I missed your videos, somehow youtube stopped notifying me. Btw, where's the video "Learn Google Spreadsheets enviou o vídeo Google Sheets Pivot Table with KPI & Bar Graphs"? I'm really interested in that one.
Yea, it's been 6+ months since youtube has been trying to tank the channel. Less than 1% of subscribers get notifications. The odd thing is if I don't post any videos the channel gets more views, if I post new videos it starts tanking the channel. So at this point I have pretty much 0 motivation to post new content. It's stupid.
KPI video will be posted at a later date.
@@ExcelGoogleSheets Oh man, keep doing your great work. On behalf of the people that watch your videos, I can say you do one of the most enlighted actions in the world: teaching. You can't imagine how positive you impact on people lives, you might be responsible for a lot of people being able to get promoted or hired on a job position. Keep going, for us!
Excellent...I learn something new
Teacher... Nice Instruction!
But how would you handle Blank Cell/s in the middle of an Athritmetic Array and keep the Math Correct?
I guess that depends on the "Athritmetic". Mostly it's some kind of IF statement.
@@ExcelGoogleSheets Teacher...how would you make Cell E4 a "Non Blank Cell" while making Cells E7, E8, E9 and E10 "True Blank Cells"?
@@Puner54
it's not clear the situation you describe, but as Teacher suggests you can try to create an IF statement and create your own ERROR i.e IF(ISBLANK(E4),IFERROR(1/0),SOMETHING)
@AuBerg
Thanks for the Reply! Do you Work with Google Sheet much?
I have one lookup sheet from which I get data for my master sheet. But some of the lookup value was not updated so I am getting the #NA error in my master sheet. So how can I add my new values from the master sheet to my lookup sheet automatically? Could you please help me with this? Thanks in advance
wait, Ctrl Shift enter is a keyboard shortcut for the array function?
Yes, it is :)
I have a problem with my IF function, its not returning the value if the result is false. I'm doing a google form with morning and afternoon time log for employees but I'm having a problem processing the data if the employee only log at afternoon.
May I ask you why you deleted / made private 2 or 3 other videos from today? Are they only by subscription or something?
They will be published at a later date.
Hello, sir, why if I want to vlookup importrange the value of a cell that contains a formula, the value of that cell doesn't appear?
Does it appear if you do importrange without a vlookup?
@@ExcelGoogleSheets I have a problem: I have 3 spreadsheet files: 1. Master data file 2. the file contains the importrange Vlookup data from the first file, it works fine 3. file contains importrange Vlookup data from second file = value not shown What is the solution? Please help. Thank You
I can't believe I've never tried that! 🤦
is tehere any way to find or replace " " with blank in excel. I tried to convert into blank cell instead of " " in excel, but it doesn't run. It shows "Not Blank"
I think you gonna have to use a macro. Something like this should work over the area selected.
for each cell in selection
if cell.value = "" then
cell.clearcontents
end if
next cell
Is there any way to get a notification when someone views my google sheet?
This fixes a HUGE immensely annoying problem when you use a script with appendRow on sheets that have an arrayformula!!!! The row gets appended after all "blank" rows.
:)
Not too many people notice these details.
@@ExcelGoogleSheets :-)
Wouldn't those be called null?
I guess they would be undefined when you pass it to the function and then the function probably returns null. Impossible to tell without seeing the implementation of the function.
@@ExcelGoogleSheets just learned that =IF(1,,)="" returns TRUE, kind of weird, as you showed up those are different for counting. Thanks for the insight.
That makes sense, because =A1="" returns true when A1 cell is actually blank.
Good lesson! Unfortunately, this method does not always work, for example, with =REGEXREPLACE(A1;"[\W]*"; ) , returns a non-empty cell (=CELL("type";B1)) "= l" - text).
That has nothing to do with this method. REGEXREPLACE function will always return text. You can say =IF(REGEXREPLACE(A1;"[\W]*"; )="",,REGEXREPLACE(A1;"[\W]*"; ))
@@ExcelGoogleSheets thanks, i already solved with filter function and regexmach like this : =UNIQUE(filter(A:A;REGEXMATCH(A:A;"\w")))
Too bad there's no way to do this in Excel without VBA.