Checking if % is correct between 2 cells

[exceluser9]

Hi There, I have a query, I have a data in column A with description column b with percent and column c with offer. I need a formula in column D2. offer in column c is constant. If C2 is SV% it should check whether B2 percent is matching with the percent mentioned in A2. if matching it should say yes or else no. in case of row 3 it should say no because its not matching. Thanks in advance

[TABLE="width: 248"]
<tbody>[TR]
[TD]Description[/TD]
[TD]Percentage[/TD]
[TD]Offer[/TD]
[/TR]
[TR]
[TD]Pinto 25%[/TD]
[TD]25%[/TD]
[TD]SV%[/TD]
[/TR]
[TR]
[TD]Harry 36%[/TD]
[TD]36%[/TD]
[TD]SV%[/TD]
[/TR]
[TR]
[TD]James 23%[/TD]
[TD]24%[/TD]
[TD]SV%[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

 

[Kamolga]

Hi there
I have a similar query

Column A Column B
A1. B1
49% Save

I need a formula, if I use save in column B and if its less than 50% it should tell true. If equal or greater than 50% it should tell false. If it's <> save it should remain blank""

Try this one

=IF(AND(B1="Save";A1<50%);"True";IF(AND(B1="Save";A1>=50%);"False";""))

 

[shg]

Or

=IF(B1<>"Save", "", A1<50%)

 

[Kamolga]

By the way, my excel version uses ; instead of ,