Dear jommo1,
I needed to say the formula y've posted is running fine however it'd be great if it could output values in " 0 , 1 and 2 "
example "0"
F2 = 0 or blank
G2 = 0 or blank
hence H2 = 0
example "1"
F2 = 50 or any other value except for 0
G2 = 0 or any other value except for 50
hence H2 = 1
example "2"
F2 = 50 or same value as G2 except for 0
G2 = 50 or same value as F2 except for 0
hence H2 = 2
please let me know if further clarification is required.