|First, are your "dots" (.) supposed to be greater than signs?|
If so, then this is what I think you are looking for:
Keep in mind that each IF has to have a value_if_true and a value_if_false argument. Your 3, 2 and 1 are your value_if_true arguments and the 2nd and 3rd IF's are the value_if_false for the preceeding IF's.
However, you don't have a value_if_false for IF(C8>5000000...) so any C8 value less than 5000000 will return FALSE since that is the default.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.