Comparing formula

[Shakynom]

Dear friends! i have a cell A2 and i want to compare this cell with B2,C2,D2,E2 and want result in F2 containing result in percentage if it is greater or lesser then 10 percent only. plz give me any solution.

 

[AliGW]

What sort of data is in those cells? Please give us at least one complete manually worked example to illustrate what you are looking for. What should appear in F2 for that example?

 

[Shakynom]

A2 = 394
B2 = 463
C2 = 372
D2 = 360
E2 = 464

this is what i have i need to get result in F2. that in A2 is rather greater or less then 10% from B2,C2,D2,E2.

 

[AliGW]

So with the values you have given above, what would the expected result be?

 

[Shakynom]

A2 B2 C2 D2 E2 F2[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]394[/TD]
[TD="class: xl63, width: 64"]394[/TD]
[TD="class: xl63, width: 64"]463[/TD]
[TD="class: xl63, width: 64"]372[/TD]
[TD="class: xl63, width: 64"]360 [/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]393[/TD]
[TD="class: xl63"]393[/TD]
[TD="class: xl63"]386[/TD]
[TD="class: xl63"]405[/TD]
[TD="class: xl63"]362[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]284[/TD]
[TD="class: xl63"]284[/TD]
[TD="class: xl63"]244[/TD]
[TD="class: xl63"]0[/TD]
[TD="class: xl63"]262[/TD]
[/TR]
</tbody>[/TABLE]

 

[Shakynom]

in percentage if it is greater then 10 or less then 10 % it shows the value

 

[AliGW]

Please answer the question. In this case:

A2 = 394
B2 = 463
C2 = 372
D2 = 360
E2 = 464

what is the expected result in F2 and why?

 

[Shakynom]

i need to compare A2 with all other cells. and want result in percentage to determine how much A2 is greater or less then with any of the other cells

 

[AliGW]

Yes, I know, but you still haven't answered my question. Here it is again.

In this case:

A2 = 394
B2 = 463
C2 = 372
D2 = 360
E2 = 464

what is the expected result in F2 and why?

 

[Shakynom]

i dnt understand you question about WHY. but i need to see what actually A2 stands for rather it is greater then or less then by any of it. if A2 is greater then 10% to any of the above cells then it shows how much its is greater then and if it is less then 10% from the above cells each then it shows how mucl less it is in percentage. and if it is not then greater or less then 10% its leaves the cell empty