"if" question
 

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?