Excel VBA - If Elseif Else Statement

Excel VBA - If Elseif Else Statement
Watch More Videos at:
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited

[TutorialsPoint_]

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

[puzabangsa]

thankyou indian dude, im using this "if" thingy for switching betwen diferent sheet and it worked great..hhehe

[lepetitalexxxou]

Seriously, the videos are great ! Thank you !

[karnabudhathoki]

One Thing that is not said explicitly but is utmost important is ...VBA codes are linear that is to say the code executes line by line from top to bottom....So if the logic is written as

if Marks <=80 then
Result= "A Grade"
ElseIf Marks <= 60 then
Result="B Grade"
ElseIf Marks<=45 then
Result="C Grade"
Else
End if

so here if your Marks is say for example 35 it will appear as "A Grade" Why? Because it is less than
But in Fact it should be C beware of these kind of situations....35 is tested against first condition first, then second then third, But because the first condition is true here, ,,,the logic ends and skips to end if line....

[bogdandacian]

Thank you very much, Sir! It helped me with my vba functions program!

[hanshimehra]

Thank u sir your method was very helpful

[soumendas]

could u pls gui how can I use If Function with Dates. I want to use the below Excel formula in vba macro : FX Spot (result Column) = If($Date2>(workday($Date1, 7)), ">T+&", IF($Date2>(workday($Date1, 72)), ">T+2", "SPOT"))...Date2 &1 are the Column Reference..pls suggest

[unboxingreviewvlog]

I purchased your online video class for Advance Excel and VBA.
ElseIf is not working in my excel vba, what should I do?

[joseernestolujanvillegas]

Indians always have the answer, thank you

[gamputerskills]

excellent work but what if i want in your case a8<35 do nothing

[msskboardp]

How can I run this for multiple grades with one function?

[gj]

Hi, I want to highlight specific set of keywords, even if it occurs multiple times.

[KLOYT]

Can we mark Value as a cell where a word start with BM*(as we do in autofiler)

[KNLP]

Jolly good, bro! You explain it damn fine! Keep up the good work

[ChineseRabbitGirl]

Sir visual code prompt is not available in my MS Excel ! Can anyone tell me where to find it MS Word ??

[TheKos]

how does it work with drop down list, i mean to auto select from drop down list.

[AnkitJainRck]

Hello Brother,
I need to create an excel where I am collecting data in 1 sheet for Cash Receipts - i want to enter these in to another sheet of same excel - How do I do this ??

[pramodchaurasia]

If you enter 200 then also you will get "A Grade" so one more condition is required...

[ahmedkamal-qjnz]

i am sorry but when i am using Elseif error appears (compile error : expected expression ) how can i solve it

[bmnone]

But if the number is 30 then it satisfied all then the conditions