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[TABLE="width: 625"]
<tbody>[TR]
[TD]NUMBER 1[/TD]
[TD]NUMBER 2[/TD]
[TD]PERCENTAGE[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.1[/TD]
[TD]45.00%[/TD]
[TD]Less than 50% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]50.00%[/TD]
[TD]Between 50% to 50.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]33.33%[/TD]
[TD]Between 33.00% to 33.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]60.00%[/TD]
[TD]More than 50% it should say it should say YES in this cell[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[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[TABLE="width: 625"]
<tbody>[TR]
[TD]NUMBER 1[/TD]
[TD]NUMBER 2[/TD]
[TD]PERCENTAGE[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.1[/TD]
[TD]45.00%[/TD]
[TD]Less than 50% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]50.00%[/TD]
[TD]Between 50% to 50.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]33.33%[/TD]
[TD]Between 33.00% to 33.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]60.00%[/TD]
[TD]More than 50% it should say it should say YES in this cell[/TD]
[/TR]
</tbody>[/TABLE]

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[TABLE="width: 625"]
<tbody>[TR]
[TD]NUMBER 1[/TD]
[TD]NUMBER 2[/TD]
[TD]PERCENTAGE[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.1[/TD]
[TD]45.00%[/TD]
[TD]Less than 50% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]50.00%[/TD]
[TD]Between 50% to 50.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]33.33%[/TD]
[TD]Between 33.00% to 33.99% it should say YES in this cell[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]60.00%[/TD]
[TD]More than 50% it should say it should say YES in this cell[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 447"]
<tbody>[TR]
[TD="colspan: 3"]=IF(D3<50,"Yes","No")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Less than 50[/TD]
[/TR]
[TR]
[TD="colspan: 4"]=IF(AND(D4>50,D4<60),"Yes","no")[/TD]
[TD][/TD]
[TD][/TD]
[TD]Between 50 to 50.99[/TD]
[/TR]
[TR]
[TD="colspan: 4"]=IF(AND(D5>33,D5<34),"Yes","no")
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Between 33 to 33.99
[/TD]
[/TR]
[TR]
[TD="colspan: 3"]=IF(D6>50,"Yes","No")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GReater than 50[/TD]
[/TR]
</tbody>[/TABLE]

 

[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

[TABLE="width: 913"]
<tbody>[TR]
[TD]NUMBER 1[/TD]
[TD]NUMBER 2[/TD]
[TD]PERCENTAGE[/TD]
[TD]FORMULA[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1.1[/TD]
[TD]45.00%[/TD]
[TD][/TD]
[TD]Less than 50% it should say yes, more tha 50% it should say no[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]50.00%[/TD]
[TD][/TD]
[TD]equal to 50% and between 50 % to 50.99% it should say yes if not no[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]33.33%[/TD]
[TD][/TD]
[TD]equal to 33% and between 33% to 33.99% it should say yes if not no[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD]60.00%[/TD]
[TD][/TD]
[TD]More than 51% it should say yes if less than 50% it should say no[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]