Drag down the formula for the next cell.Here in the above screenshot, we can see that Amazon MRP is equal to Flipkart MRP, so we will get the output as FALSE, which is shown in the below screenshot.Excel will check if B3 values are not equal to C3, then it returns TRUE or else it will return FALSE.So as we can see in the above screenshot, we applied the formula as =B3C3 here, we can see that in the B3 column Amazon MRP is 1400, and Flipkart MRP is 1400, so the MRP matches exactly.Apply the formula in excel as shown below.Now we are going to check that Amazon MRP is not equal to Flipkart MRP by following the below steps.
In this example, we are going to see how to use the Not Equal To logical operation in excel.Ĭonsider the below example, which has values in both the columns now we are going to check the Brand MRP of Amazon and Flipkart. You can download this Not Equal To Excel Template here – Not Equal To Excel Template Example #1 – Using ‘ Not Equal To Excel ‘ Operator
0 kommentar(er)
