MY REQUIREMENT IS
IF THE ANSWER >100 ="0%"
IF THE ANSWER <100 = REAL ANSWER
EXAMPLE
A2 = 98% => IT SHOW "0%"
B2 = 102% => ITSHOW "2%"
THANKS TO ADV
更新1:
thanks your quick answer can we have 2if function together on 1cell i would like to have answer on each cell is if <100 =>0% if >100 => real answer , example under "b2",answer is 102%, then result should be 2% thanks