greater than larger than

[excel]

say cell a1 has a figure, say 10, and i want that figure to put into
cell b1, a 1, if the figure in a1 is less that 8 but greater than 0,
how would i express that in a formula?

 

[Pete_UK]

I think you mean this in B1:

=IF(AND(A1<0,A1<8),1,0)

will put 1 into B1 if A1 is between 0 and 8, otherwise B1 will be set
to zero.

Hope this helps.

Pete

 

[Fred Smith]

I'm sure Pete means:

=IF(AND(A1>0,A1<8),1,0)

 

[Pete_UK]

Yes, I did Fred - thanks (bit late here in the UK !!)

Pete

 

[excel]

Yes, I did Fred - thanks (bit late here in the UK !!)

Pete




- Show quoted text -

Thank you both, worked a treat.

Esra

 

[Guest]

=(A1>0)*(A1<8)