I'm writing a formula and struggling to get past one issue.
The formula looks like this:

=if(c9=x18,(y18*g6),if(c9=x19,(y19*g6),if(c9=x2 0,(y20*g6)

x18=100%
y18=$99
x19=125%
y19=$124
x20=150%
y20=$155
etc.
The issue is that even when c9=358% the calculation is basing off of the
first formula so it seems to be saying "358% is than 100% so we are going
to multiply g6 by $99" when I want it to recognize that 358% is actually
greater than 150% and multiply g6 by $155. can someone point out where I'm
going wrong?