MS Excel - Not and If Error

MS Excel - Not and If Error
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.

[DigiocityDigitalTech]

Your way of teaching is good. Even being a girl, I have learnt a lot and created my own technology channel named as” Digiocity Digital “ . Thanks Sir.🎉❤😅

[saubhagyaswain]

It would be great if you can sight examples where these functions are useful. You use to give corporate examples in your previous videos while explaining. Please continue so as we can learn where a particular function gets used.

[vishalshah]

Is there any coaching in the classroom...

[abbasshah]

dear sir
can you help me to know, if any formula to detect error for example we are writing 422.56 and we have written 422..56, or we want to write any value and we specify that value should not go more than fixed value if goes than it indicates mistake for example we want to write that value should be 50500 and if any value go more than this value it indicate error

[akshatjain]

How to decide when and where to use AND, if, nested if function?

[SathishKumar-npsc]

Is it only applicable for TRUE OR FALSE statement..?? OR function has been missing..??

[serhatugurneodym]

I use excel 2007 edition and I am facing with a lot of different applications, for example when I apply the formula the last one stays the same, another name it not written "skip this".

[boddamlikhitha]

Hlo sir
I tried iferror()
for example iferror (fass) it not showing any error same result given for 1/0 also..pls tell where iam wrong

[manumichael]

I am using IFERROR Formula in B8 cell (+, -, *, ) It is not empty coming to the value showing " 0" Using the Formula =IFERROR(B6*B7, "") This formula using. The cell B6 & B7 empty B8 still Showing Value "0" Please Comment the Solutions.

[ΜαρίναΚολοη]

= ISERROR( ISEVEN(“2000”) ) whats a result?

[saubhagyaswain]

NOT Function - Sir I have a Doubt in NOT Function. Is it applicable only when we have "TRUE"/"FALSE" cases? Will it not be applicable on "YES", "NO", "RIGHT", "WRONG" etc? Please Clarify.
NOTE - I tried on these as practises and it throws error as #VALUE!

[Steja]

Sir, i couldn't find "OR" function video.Please upload it.

[ShivangiSingh]

how does excel know what is the error?