MrsFrankieH
Active Member
- Joined
- Mar 25, 2011
- Messages
- 323
- Office Version
- 365
- Platform
- Windows
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
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