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.

 

[Shakynom]

Actually these are rates of hotel and A2 is my hotel. and i need to see how much other hotels are high or low in price. but i just need 10% high values and 10% low values.

 

[AliGW]

OK - we are getting there. You have just explained the why, so what is your expected result in F2 for this data?

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

I am not going to attempt to provide a solution until you give me this information.

 

[Shakynom]

if my hotel A2 is higher then 10% then it shoes the actuall value in percentage. and if it is less then 10% then it hows empty cell

 

[AliGW]

And what is the expected outcome for the series of data in post #12? Why are you unable to answer this simple question? If you want someone to spend time constructing a formula for you, then you need to be prepared to give them the information they request. Let's put it this way: I am not going to waste my time trying to solve this until I have an expected outcome to work with. All helpers here give of their time freely and without recompense.

 

[Shakynom]

any solution MR.Ali ???

 

[AliGW]

Not until you answer my question.

What is your expected result in F2 for this data?

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

By the way, I am a Miss, not a Mr.

 

[Shakynom]

Miss........ i need result in percentage..... ok leave it please tell me how can i compare them if thay are in percentage values. mean A2 to is 394% and B2 is 463% and C2 is 372%. i want the result to come if thay are higher then 450%

 

[AliGW]

OK - I've tried several times now over a period of 90 minutes (as long as a complete football match) to get you to tell me what that result should be, and you have failed to do so. Hopefully somebody else will have the patience to take this on. Good luck!

 

[Shakynom]

Dear miss i just want to compare them with A2. and want the result in F2 or in more cells rather A2 is greater then these cells if it is greater then 10% it shows "yes'

 

[Aladin Akyurek]

Dear miss i just want to compare them with A2. and want the result in F2 or in more cells rather A2 is greater then these cells if it is greater then 10% it shows "yes'

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][/tr][tr][td]

1​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td]

2​

[/td][td] 394[/td][td] 394[/td][td] 463[/td][td] 372[/td][td] 360[/td][td] [/td][/tr]
[tr][td]

3​

[/td][td] 393[/td][td] 393[/td][td] 386[/td][td] 405[/td][td] 362[/td][td] [/td][/tr]
[tr][td]

4​

[/td][td] 284[/td][td] 284[/td][td] 244[/td][td] 0[/td][td] 262[/td][td] [/td][/tr]
[tr][td]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

This is your sample. What is the value that must obtain in F2? Please calculate the value and post that value.