You are here:Home » Office Tricks » Microsoft Excel IF Condition, If 1 Put 0 & If 0 Put 1, Formula

Microsoft Excel IF Condition, If 1 Put 0 & If 0 Put 1, Formula

What is Microsoft Excel?
Why it's used?

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.  

Excel IF Condition, 

IF is keyword use to check mathematical conditions in excel. In other words you can check condition like. IF is mostly used in every programming like C, C++, Java, PHP, Ruby on Rails etc. 
IF A==0 PUT True or IF A==1 PUT False 
The above example is prefect to show you about why IF is used in excel and programming.

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

Microsoft Excel IF Condition

Solution of Problem

IF(A3=1,"0", IF(A3=0,"1"))
Microsoft Excel IF Condition
Microsoft Excel IF Condition