"Travelgirl333" wrote:
I want to create a formula that has multiple criteria. For example if
cell B2 falls between 0-25% is cell C2 70% or greater. If yes, then
count. Basically I have four requirements for cell B2
0-25% then C2 must be 70% or higher to count
26-35% then C2 must be 75% or higher to count
36-45% then C2 must be 80% or higher to count
46 or greater then C2 must be 90% or higher to count
I'm not sure if I can create one embedded formula or have to write
separate formulas for each criteria above.

Not sure what you mean by "to count" when talking about a single pair of
cells, B2 and C2.

If you mean that you are looking at a range of rows, for example B2:B100 and
C2:C100, and you want to count the number of pairs that qualify, then:

=SUMPRODUCT(--((B2:B100<=25%)*(C2:C100=70%)
+ (B2:B10025%)*(B2:B100<=35%)*(C2:C100=75%)
+ (B2:B10035%)*(B2:B100<=45%)*(C2:C100=80%)
+ (B2:B10045%)*(C2:C100=90%)0))

or

=SUMPRODUCT(--((B2:B100<26%)*(C2:C100=70%)
+ (B2:B100=26%)*(B2:B100<36%)*(C2:C100=75%)
+ (B2:B100=36%)*(B2:B100<46%)*(C2:C100=80%)
+ (B2:B100=46%)*(C2:C100=90%)0))

The choice depends on your intended meaning of the ranges 0-25% v. 26-35%.
Note that there are an "infinite" number of values between 25% and 26%
unaccounted for, unless you ensure that B2 is rounded to 2 decimal places.