Google Sheets Apps Script - If, Then, Else If, Else JavaScript Statements Tutorial - Part 6

Video tutorial series about Apps Script (JavaScript) in Google Sheets (Excel VBA Equivalent).

In this tutorial we'll cover how to use If, Then, Else If, Else statements in Google Sheets scripts.

Google Sheets

Website:

[MuhammadIbrahim-zcvx]

Of all the tutorials I have seen, all the channels, you sir are truly a fine tutor. You explain things very nicely.
I have learnt the most from you
Thanks a lot!

[profocelsomarin]

tag times
if = (começo) 4:00
else = 7:05
loop = (para iterar em um range) 8:10
loop = (atenção com a sintaxe "{}" usar a tabulação para evitar erros) 9:00
variável i = aplicando i na execução de if statements 10:17
else if = para ter mais teste lógicos 11:42
ordem dos if statements = (pensando a ordem das senteças) 14:22
múltiplos else if = 16:26

[Tsunamiatunzen]

Some of the language wasn't functioning for me at first but it put me on the right track. Thanks!

[trasformtessilesrl]

thanks !! you saved me!
simple and clear!!! exactly what i need to learn, and noone explain it good and simple like YOU!!

[michaeltimpano]

Thanks for sharing your knowledge and expertise. I am learning so much from your video tutorials. I wish I could just work with you directly to complete some custom scripts for projects I am working on! These videos have been very helpful. Take care and all the best.

[admireargumentactivity]

1:16 from 1h of tutorial binging the tutorialseries i most thankful for that sleight

[jonhollandWales]

How can you use the If, else if to select different google docs templates based on an input from a cell. For example Option A selected in the cell populate template A, Option B selected populate template B. Love your videos, share them with colleagues when they're stuck

[LanguageBLOX_Alt]

thanky you! please continue if you can I am loving this!

[costaluca]

thank you so MUCH, this tutorial helped me a lot! Very clear explanation! well done

[khanyameyiswa]

You explain so nice sir. You should create a course on UDEMY

[harcelld]

Really helpful, thanks. What If I'd like to run a function when some criteria is met? I already have my function working, but I'd like to run it only when something is written in a specific cell.

[MiguelHernandez-oetl]

Thank you for your videos!. How could I get the selected item in a drop-down list in google form?

[yadday]

Can you refer to a core function in a custom function?

[khanyameyiswa]

Got it sir no problem. I changed my else statement to else if. My for loop contained else ifs only

[computercomputer]

is there a way to save a macro for it to be use on other worksheets. Something like excels' " personal "

[BlokeBritish]

i need to allow users to write to my sheet through a script but users should not be able to view/open the sheet manually.
the script needs to capture current user email.
is this possible ?

[rnp]

Are rows 3-4 only necessary when your function doesn't have a variable between the parentheses on line one?

[adelsonduarte]

Is it possible to hide the rows or columns in Google Sheets from a condition being executed by a Script?

[computergeeks]

Can you make script for timestamp that won't change when the data is updated > for 'created date' column; and timestamp for 'edited date' column. I need the format in dd-mmm-yyyy. Thank's

[gaurishankar]

Is there any code to execute countif function through script editor