I am trying to put a formula together using share ranges eg

if x(a number) is greater than (y) but less than (z) then calculate this or nothing

I cannot figure out how to do this anyone help

 

Well here's the logic tests etc....

=IF(AND(A1>B1,A1<B2),C1*D1,0)

A1, B1 etc are cell references so in your example A1 is 'x', B1 is 'y', B2 is 'z'. C1*D1 is just an example calculation if x>y & x<z. If that is not the case, zero is returned. If you put this in cell E1 for example, you would see either C1*D1 or zero, depending on what is in A1, B1, B2....

HTH


Probably a better solution to come though

 

Excellent this one works a treat cheers made me a happy chappy today

Thanks again, been sat pondering this one for hours.

Thick monkey me

 

We aim to please