I am trying to do one of two execution in a cell. The first is if cell length is = 17 then cell = h7; however if cell length = 9 then add a zero to cell h8 and copy the first to characters from a8 to h8. So if a8 = 123456789 then a zero to h8 and copy the first two chracters. so the result for this example would be: h8 = 012. below is the code i have but it just wont execute the expected result (note: i am learning so go a bit easy ok).

=if(len(a8) = 17, hf, if(a8 = "","","0"&left(a8,2))
Thanks for assisting.