On Wednesday, August 19, 2020 at 9:49:08 AM UTC-10, ymadi wrote:
Hello,
I'm trying to increment using two criteria; Category (Primary #) and
Question(Secondary #). Categories will be 1, 2, 3, and the questions
that fall under each category will increment by 0.1 (i.e. 1.1, 1.2,
etc..). I'm using the formula B2+0.1. It works great up until it reaches
1.9, but after that, it jumps to 2. It should display display it as
1.10.

Ive attached a screenshot to illustrate what Im trying to do.

One more thing (Sorry lol), I've also noticed that 1.10 will display as
1.1 creating a duplicate. I'll be using these numbers as IDs, so it's
important that they're unique..

Thanks in advance for all your help


+-------------------------------------------------------------------+
|Filename: Increment Help.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1069|
+-------------------------------------------------------------------+



--
ymadi

Your spreadsheet is calculating correctly based on the data you are inputting. Row 3 in your range already has the 1.1 value you want returned in Row 12. As you note, there is no difference in the numbers 1.1 and 1.10 so your calc would create a duplicate number anyway. Maybe you want to work in true hundreths instead of tens: 1.10, 1.11, 1.12, 1.13, 1.14.... 2.10, 2.11, 2.12, 2.13, etc.
HTH

Hi Miles!
Thanks for responding! You're absolutely right and it did worked :) I was so focused on making the logic smarter, that I did think about this simple mathematical solution lol.

Again, thanks for all your help.

Yasser

Miles Baidack wrote:

On Wednesday, August 19, 2020 at 9:49:08 AM UTC-10, ymadi wrote:
Hello,
I'm trying to increment using two criteria; Category (Primary #) and
Question(Secondary #). Categories will be 1, 2, 3, and the questions
that fall under each category will increment by 0.1 (i.e. 1.1, 1.2,
etc..). I'm using the formula B2+0.1. It works great up until it reaches
1.9, but after that, it jumps to 2. It should display display it as
1.10.

I've attached a screenshot to illustrate what I'm trying to do.

One more thing (Sorry lol), I've also noticed that 1.10 will display as
1.1 creating a duplicate. I'll be using these numbers as IDs, so it's
important that they're unique..

Thanks in advance for all your help

Your spreadsheet is calculating correctly based on the data you are
inputting. Row 3 in your range already has the 1.1 value you want
returned in Row 12. As you note, there is no difference in the numbers
1.1 and 1.10 so your calc would create a duplicate number anyway. Maybe
you want to work in true hundreths instead of tens: 1.10, 1.11, 1.12,
1.13, 1.14.... 2.10, 2.11, 2.12, 2.13, etc. HTH

You'll have to treat the data as strings (watch the word wrap):

=IFERROR(LEFT(A1,FIND(".",A1))&MID(A1,FIND(".",A1) +1,LEN(A1)-FIND(".",A1))+
1,A1)

There's probably better ways to do it, but this works for me.

--
Your mileage may vary. Results not guaranteed.
Warranty void in the United States, England, and the planet Earth.

On Thursday, August 20, 2020 at 3:49:50 PM UTC-5, Auric__ wrote:
Miles Baidack wrote:

On Wednesday, August 19, 2020 at 9:49:08 AM UTC-10, ymadi wrote:
Hello,
I'm trying to increment using two criteria; Category (Primary #) and
Question(Secondary #). Categories will be 1, 2, 3, and the questions
that fall under each category will increment by 0.1 (i.e. 1.1, 1.2,
etc..). I'm using the formula B2+0.1. It works great up until it reaches
1.9, but after that, it jumps to 2. It should display display it as
1.10.

I've attached a screenshot to illustrate what I'm trying to do.

One more thing (Sorry lol), I've also noticed that 1.10 will display as
1.1 creating a duplicate. I'll be using these numbers as IDs, so it's
important that they're unique..

Thanks in advance for all your help

Your spreadsheet is calculating correctly based on the data you are
inputting. Row 3 in your range already has the 1.1 value you want
returned in Row 12. As you note, there is no difference in the numbers
1.1 and 1.10 so your calc would create a duplicate number anyway. Maybe
you want to work in true hundreths instead of tens: 1.10, 1.11, 1.12,
1.13, 1.14.... 2.10, 2.11, 2.12, 2.13, etc. HTH
You'll have to treat the data as strings (watch the word wrap):

=IFERROR(LEFT(A1,FIND(".",A1))&MID(A1,FIND(".",A1) +1,LEN(A1)-FIND(".",A1))+
1,A1)

There's probably better ways to do it, but this works for me.

--
Your mileage may vary. Results not guaranteed.
Warranty void in the United States, England, and the planet Earth.