Combining IF, OR and MIN

[Kribulin]

I currently have the following condition set:

= I F ( A 1 0 < G $ 4 ; 0 ; M I N ( G $ 5 ; B 1 0 ) )<g$4;0;min(g$5; b10))="">

Now I want to add that if A10 is bigger than G6, the value is also 0.

But as I try to add this condition like this:
</g$4;0;min(g$5;> = I F ( A 1 0 < G $ 4 O R ( A 1 0 > G 6 ) ; 0 ; M I N ( G $ 5 ; B 1 0 ) )<g$4;0;min(g$5; b10))=""><g$4 or="" (a10="">

it doesn't work. What's false?

Thanks in advance!
</g$4></g$4;0;min(g$5;>

 

[Kribulin]

Sorry, I have problems posting the code, so I justed added blanks in it in the original post.
<g$4 or="" (a10=""></g$4>

 

[Mike Blackman]

Hi,

Try;

=IF(OR(A10<G$4,A10>G6),0,MIN(G$5;B10))

When posting with multiple <'s >'s use the PhP Code Tags

 

[Kribulin]

Brilliant, thank you!