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]

=if(and(C2="SV%",B2=numbervalue(right(A2,3))),"yes","no")

I am not sure numbervalue() is mandatory

 

[exceluser9]

Hi Sir, formula isn't working, it says #NAME?
Any suggestions?

 

[Chrisdontm]

I checked KAMOLGA's answer and it appears to do what you are asking...

( it seems that you do have to have the NUMBERVALUE part )

Look it over a bit more, maybe copy and paste in a response what you are typing...

 

[exceluser9]

The number value is not constant ot keep changing, so I cannot put specific number value all time

 

[Chrisdontm]

The formula allows for that...it should work.

Copy the formula that you typed in, and paste it into a message to us...

 

[exceluser9]

=if(and(C2="SV%",B2=numbervalue(right(A2,3))),"yes","no")

I am not sure numbervalue() is mandatory

This is what i have tried in D2 - =IF(AND(C2="SV%",B2=numbervalue(RIGHT(A2,3))),"yes","no")

it says #NAME?

Also tried this =IF(AND(C2="SV%",B2=25*(RIGHT(A2,3))),"yes","no")

It says no for everything

Am i doing any thing wrong, please help

 

[Chrisdontm]

Your second attempt is always going to say "no" because you are times-ing the column "A" percent by 25.

Your first example appears to be typed in, not copied. The words "numbervalue" are in lower case, they would have been upper case.

I suggested that you copy it because it must be a small detail missing...

It will be a few hours before I can get back to a computer...

 

[Kamolga]

This is what i have tried in D2 - =IF(AND(C2="SV%",B2=numbervalue(RIGHT(A2,3))),"yes","no")

it says #NAME?

Also tried this =IF(AND(C2="SV%",B2=25*(RIGHT(A2,3))),"yes","no")

It says no for everything

Am i doing any thing wrong, please help

If it says "Name" it rather means you forgot the " " for SV% / yes / no or your version of Excel does not support numbervalue function (I do not know anything about this as I barely use it)...but the function value works for all my clients.


So this one

=if(and(C2="SV%",B2=value(right(A2,3))),"yes","no")

, I hope, should work (they both work on mine)


Note that for this =IF(AND(C2="SV%",B2=25*(RIGHT(A2,3))),"yes","no") to have a chance to work it should be 1 after A2, as you want to multiply 25 by the first caracter on the right of A2 ->% : right(A2,3) means you take 3 caracters, so 25*25%

 

[exceluser9]

Its working sir, thank you