Just FYI, here is how it would look with an IF function:

=IF(A1>1000000,"large",IF(A1>=100000,"Medium",IF(A1< 100000,"small")))

which can be shortened to

=IF(A1>1000000,"large",IF(A1>=100000,"Medium","small"))