inquiries < 11 ; "tier 3" ;
inquiries < 26 ; "tier 2" ;
this works great for just numbers. but it doesnt work for $$amounts and %% ammounts any ideas
Please, write down what could be inside the "inquiries" field.
( more examples you'll write, more reliable would be the answer )
Inquiries is flawless... Thank Yoy so Much
but i have 2 more to do that are not working using your exact formula.
Closing % field
below 50% = tier 3
below 71% = tier 2
anything over 71% = tier 1
below $7150.00 = tier 3
below $10400.00 = tier 2
anything over 10401.00 = tier 1
Those are the 2 other things that are not working. Any help is great thank you
thank you so much all i had to do is use teh number as a decimal.