When you use IF function you should specify what needs to be returned if condition is TRUE or FALSE.
If you need to classify amount by category you can use something like this:
Assuming your data starts in A1
=LOOKUP(A1,{1000000,2000000,3000000,4000000},{"MIN","MID","LARGE","LARGEST"})
Drag formula down.
Bookmarks