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. &nbs
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.
#Web
Share this post