greater than larger than
 

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?

greater than larger than
 

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

On Sep 21, 11:07 pm, excel wrote:
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?

greater than larger than
 

I'm sure Pete means:

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


--
Regards,
Fred


"Pete_UK" wrote in message
ups.com...
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

On Sep 21, 11:07 pm, excel wrote:
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?

greater than larger than
 

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

Pete

On Sep 21, 11:58 pm, "Fred Smith" wrote:
I'm sure Pete means:

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

--
Regards,
Fred

"Pete_UK" wrote in message

ups.com...



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

On Sep 21, 11:07 pm, excel wrote:
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?- Hide quoted text -

- Show quoted text -

greater than larger than
 

On Sep 22, 11:13 am, Pete_UK wrote:
Yes, I did Fred - thanks (bit late here in the UK !!)

Pete

On Sep 21, 11:58 pm, "Fred Smith" wrote:



I'm sure Pete means:

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

--
Regards,
Fred

"Pete_UK" wrote in message

oups.com...

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

On Sep 21, 11:07 pm, excel wrote:
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?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Thank you both, worked a treat.

Esra

greater than larger than
 

=(A10)*(A1<8)


"excel" wrote:

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?