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]

Its working sir, thank you

You are welcome, thank you for letting us know and glad it does

 

[MARK858]

or your version of Excel does not support numbervalue function (I do not know anything about this as I barely use it)

NumberValue came in with Excel 2013 and so earlier versions don't support it.


http://support.office.com/en-us/Article/New-functions-in-Excel-2013-075c82bd-15b9-4ad6-af31-55bb6b011cb9

 

[exceluser9]

Instead of SV% if I use any other offer like save price it should still say blank but it says false any help?

 

[MARK858]

Can you post the exact formula you are currently using because if you are using the formula kamolga posted it should be saying no not false?

 

[Kamolga]

Can you post the exact formula you are currently using because if you are using the formula kamolga posted it should be saying no not false?

That is right it should say "no", not false. I guess your formula looks like =xxx=123

 

[Kamolga]

Instead of SV% if I use any other offer like save price it should still say blank but it says false any help?

=if(and(or(C2="SV%",C2="[COLOR=#0000ff]save price[/COLOR]"),B2=value(right(A2,3))),"yes","no")

This will say yes if C2 = SV% or save price

 

[Kamolga]

For a blank on any value but CV% you can use

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

 

[exceluser9]

Its working as requested, thank u so much

 

[Kamolga]

You are welcome

 

[exceluser9]

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