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?

I tried to change the parentheses and it did not change the outcome. It
seems like it is only recognizing the first one and multiplying everything by
y18, regardless of the value of C9.

"Dave F" wrote:

Well, first thing is you need to check your parentheses.

Looks like it should be:
=if(c9=x18,y18*g6,if(c9=x19,y19*g6,if(c9=x20,y2 0*g6,""))

Does that change your outcome?

"Liz" wrote:

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?