=IF Statement issue

[dmcgetti]

I am trying to to us an IF statement to sum prices depending on what is in another column.


This is the formula I am using in Q2:


=IF(M2=2%,J2*0.98,IF(M2=13%,J2*0.87,))


and here is my data:

J	K	L	M	N	O	P	Q
975	0	R	2%
1260	250.00	R	13%				1096.20

<tbody>
</tbody>

It works fine on the "13%" but not the "2%"

 

[gaz_chops]

Then the formula should work.

 

[dmcgetti]

Then the formula should work.

It does, I was over analyzing, Thank You!

 

[gaz_chops]

You're welcome.