What is Microsoft Excel?
You all know Microsoft Excel is package of Microsoft Office, Microsoft excel is spreadsheet application developed by Microsoft to use on Windows, iOS and etc. It's used to calculate, make graphs and prepare pivot charts. The best part of excel is it supports macro programming support from Microsoft visual basic, you can do programming to complete your task or complicated calculation.
Why it's used?
Excel IF Condition,
IF A==0 PUT True or IF A==1 PUT False
Now here we are talking about the condition, IF 1 PUT 0 & IF 0 PUT 1, it is very simple to solve this problem, if you are programmer then you will in seconds, if not then that will take time to know.
Syntax for IF Condition
IF( condition, [value_if_true], [value_if_false] )
Problem in Excel
IF 1 PUT 0 & IF 0 PUT 1
Solution of Problem