Using IF in MS-EXCEL to display conditional value/text
Way 1: Campare two numbers and print the greater one
=IF((10>20),”TEN”,”TWENTY”);
Way 2: Subtract CELL ( A2 ) from CELL (A1) and find if A1 is bigger or smaller.
=IF( ( (A1 – A2) > 0 ) ,”A1 is Bigger “,”A1 is Smaller”);
Note: Always wrap condition part within brackets.
Leave a Reply