trying to check for either of two conditions in a cell

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).

Please Login or Register  to view this content.

Thanks for assisting.

what is your hf?

Originally Posted by jakeisbill

what is your hf?

HF has a default code that i want the cell to populate if the length is = 17. An example of what would be in HF is: 035

Thank you "K m" for your prompt yet accurate response. Wow you guys make make things seem easier than they appear.

I am from Jamaica so I will give my usual Jamaican Thank you!

Km yu a di Bhass (boss pronounced with a a), bless up!

Originally Posted by K m

=if(len(a8)=17,h7,if(len(a8)=9,"0"&left(a8,2),""))