I am trying to create a nested if formula. I am trying to build the following formula: If a # value is over 1,000,000, the field would fill with “Mega Influencer”If a # value is 100,000-999,999, the field would fill with “Macro Influencer”If a # valu...