Excel formula Doesn't work

[vat123]

Hi I have got a formula mentioned below that doesn't work. First two parts of the formula works but not the last condition. Anyone could help please?


=IF(K6="No","-",IF(OR(K6<H6),0%,IF(AND(K6>=J6),200%,IF(K6>=H6,(50%+(K6-H6)*10),IF(K6>=I6,(100%+(K6-I6)*20),Error )))))

 

[oldchippy]

Hi vat123,


Welcome to the forum, your formula doesn't make sense as it is, so could you give an example of the values in cells H6:K6 and the expected result, then it should become clearer to us.


Thanks

 

[vat123]

Hi Oldchippy,

Thank you for welcoming me to the blog.


The values are

H6: 90

I6: 95

J6: 100

K6 : can vary from 90 to 100


Does that answer your question?

 

[oldchippy]

Hi,


Not yet, but from those figures you have provided, what result would you expect to get?

 

[Hui]

Error should be "Error"

 

[vat123]

Hi,

I actually figured it out.

But i am not sure how will i expalin.

Since i am a new bee to blogging its bit difficult for me to explain.

But i really liked the blog and response time.

I will think how could i explain and will post soon..


Thanks for your efforts guys!!!

 

[Hui]

Vat123


Maybe post the formula here so we can see what you were after?