Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to return larger value | Excel Discussion (Misc queries) | |||
How do I get a larger font in the HELP panels? | Excel Discussion (Misc queries) | |||
Importing from a larger csv | Excel Discussion (Misc queries) | |||
IF in combination with larger than | Excel Worksheet Functions | |||
I need a larger "IF" Formula... | Excel Discussion (Misc queries) |