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:
<tbody>
</tbody>
It works fine on the "13%" but not the "2%"
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%"