HELP! If Statement with multiple conditions

[Nomanland]

I need an IF Statement with multiple conditions and my formula is not working:

=IF(G12=<100000, IF(G12>200000, IF(G12>300000, 1, 0), 0), 0) where G12 is an actual value.

It came with an error.

I want: If the total number of the value reached 100,000, add one. Again, in the same cell, if it reached another 100,000 (200,000 or more) add one in the same cell which makes it two and so on. So How do I create a formula to meet my condition?

Thanks.

I'm new to this forum btw!

 

[MistaCy]

I know this isn't exactly what you're asking for, but this code will return a value of 0 when cell G12= anything less than 100,000. anything between 100,000 and 199.999 will return 1. Anything 200,000 to 299.999 will return 2. And so on. This code will keep working no matter how large your number is.

=rounddown(c12/100000,0)

 

[Nomanland]

Wow, I never knew rounddown statement before but thanks!

 

[MistaCy]

Did that accomplish what you needed?

 

[Nomanland]

Did that accomplish what you needed?

Yep, it does! Thanks again.