=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%"

 

[GlennUK]

Are you simply trying to apply a percentage calculation? Like:
=J2*(100%-M2)

 

[dmcgetti]

Are you simply trying to apply a percentage calculation? Like:
=J2*(100%-M2)

No, but you helped me find another error!

The formula should read:

=IF(M2=2%,J2*0.89,IF(M2=13%,J2*0.76,))

 

[GlennUK]

And what if the percentage is neither?

 

[gaz_chops]

Is M2 actually 2%? Or is it maybe 2.01% showing no decimal places?

 

[dmcgetti]

And what if the percentage is neither?

Everything will be either "2%" or "13%"

 

[dmcgetti]

Is M2 actually 2%? Or is it maybe 2.01% showing no decimal places?

No they are are exact, checked.

 

[gaz_chops]

Everything will be either "2%" or "13%"

Then you don't need the 2nd if.

=IF(M2=2%,J2*0.89,J2*0.76,))

 

[gaz_chops]

No they are are exact, checked.

So if you enter 2% in a blank cell, say A1, then type in B1
=A1=M2
What answer do you get?

 

[dmcgetti]

Then you don't need the 2nd if.

=IF(M2=2%,J2*0.89,J2*0.76,))

Maybe I am using the wrong formula, this is what I am trying to do:

If M2 is "2%", than I want to multiply J2 by .89. If the amount in M2 is "13%", I want to multiply J2 by .76.