Double digit formula

[MrsFrankieH]

Hello everyone.

My Computer is Asus

My operating system is Windows 10.

Can I get help with a formula?

My objective is to have a formula that can double the first number of a two-digit number.

The range is 1 to 43, so numbers in the 40’s wouldn’t be doubled since it would be out of range.

Numbers from 1 to 9 will be blank and duplicates would also show up blank as illustrated below.

​

Thank you so much for your help in advance.

With gratitude,

Mrs. F

 

[MrsFrankieH]

Thank you Peter! Sorry for the late reply, I had illness in my family.

 

[MrsFrankieH]

Read MARK858's signature block below each if his posts....or mine.

Thank you Peter!! I'm sorry for the delayed response, I had illness in my family.