If formula to check percentage

[exceluser9]

Hi there, I have a data like this, I have put a formula in column D to chack the percentage difference of column b and column c, in column E I need a formula as per my requirement mentioned in Column E. Please help

Please help

NUMBER 1	NUMBER 2	PERCENTAGE	FORMULA
2	1.1	45.00%	Less than 50% it should say YES in this cell
4	2	50.00%	Between 50% to 50.99% it should say YES in this cell
3	2	33.33%	Between 33.00% to 33.99% it should say YES in this cell
5	2	60.00%	More than 50% it should say it should say YES in this cell

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[Fishboy]

Hi there, I have a data like this, I have put a formula in column D to chack the percentage difference of column b and column c, in column E I need a formula as per my requirement mentioned in Column E. Please help

Please help

NUMBER 1	NUMBER 2	PERCENTAGE	FORMULA
2	1.1	45.00%	Less than 50% it should say YES in this cell
4	2	50.00%	Between 50% to 50.99% it should say YES in this cell
3	2	33.33%	Between 33.00% to 33.99% it should say YES in this cell
5	2	60.00%	More than 50% it should say it should say YES in this cell

<tbody>
</tbody>

By the looks of your request, the "rule" for each row is different to obtain a "YES" answer. As such I dont think a single formula is going to help you here. It looks like you would need to tailor the formula required for each individual row.

 

[uk747]

Hi there, I have a data like this, I have put a formula in column D to chack the percentage difference of column b and column c, in column E I need a formula as per my requirement mentioned in Column E. Please help

Please help

NUMBER 1	NUMBER 2	PERCENTAGE	FORMULA
2	1.1	45.00%	Less than 50% it should say YES in this cell
4	2	50.00%	Between 50% to 50.99% it should say YES in this cell
3	2	33.33%	Between 33.00% to 33.99% it should say YES in this cell
5	2	60.00%	More than 50% it should say it should say YES in this cell

<tbody>
</tbody>

=IF(D3<50,"Yes","No")				Less than 50
=IF(AND(D4>50,D4<60),"Yes","no")			Between 50 to 50.99
=IF(AND(D5>33,D5<34),"Yes","no")			Between 33 to 33.99
=IF(D6>50,"Yes","No")				GReater than 50

<tbody>
</tbody>

 

[Maverick27]

You need to write a Nested IF Statement

Syntax:

[COLOR=#333333][FONT=Menlo]IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))[/FONT][/COLOR]

Example: Nested If in Excel - Easy Excel Tutorial

Note: You can nest upto 7 IF functions to create a complex IF THEN ELSE statement.

 

[exceluser9]

Hi Sir,

Formula is not working

NUMBER 1	NUMBER 2	PERCENTAGE	FORMULA
2	1.1	45.00%		Less than 50% it should say yes, more tha 50% it should say no
4	2	50.00%		equal to 50% and between 50 % to 50.99% it should say yes if not no
3	2	33.33%		equal to 33% and between 33% to 33.99% it should say yes if not no
5	2	60.00%		More than 51% it should say yes if less than 50% it should say no

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>