| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater Than 24 But Less Than 48 - If Statement
I want a €œ1€ to appear in cell N2 if in cell M2 I have greater than 24 but
less than 48. This is the IF statement that I have so far in cell N2. =IF(Sheet1!M2=25,1,""). What do you think? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than 24 But Less Than 48 - If Statement
On Tue, 3 Feb 2009 12:43:01 -0800, Workbook
wrote: I want a “1” to appear in cell N2 if in cell M2 I have greater than 24 but less than 48. This is the IF statement that I have so far in cell N2. =IF(Sheet1!M2=25,1,""). What do you think? Try this formula: =IF(AND(Sheet1!M224,Sheet1!M2<48),1,"") Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than 24 But Less Than 48 - If Statement
Hi
Try this =IF(AND(Sheet1!M224,Sheet1!M2<48),1,"") Mike "Workbook" wrote: I want a €œ1€ to appear in cell N2 if in cell M2 I have greater than 24 but less than 48. This is the IF statement that I have so far in cell N2. =IF(Sheet1!M2=25,1,""). What do you think? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than 24 But Less Than 48 - If Statement
Thank you, this is very helpful to me.
"Lars-Ã…ke Aspelin" wrote: On Tue, 3 Feb 2009 12:43:01 -0800, Workbook wrote: I want a €œ1€ to appear in cell N2 if in cell M2 I have greater than 24 but less than 48. This is the IF statement that I have so far in cell N2. =IF(Sheet1!M2=25,1,""). What do you think? Try this formula: =IF(AND(Sheet1!M224,Sheet1!M2<48),1,"") Hope this helps / Lars-Ã…ke |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than 24 But Less Than 48 - If Statement
Fantastic! Thank you Mike. You're input is valuable to me.
Ed "Mike H" wrote: Hi Try this =IF(AND(Sheet1!M224,Sheet1!M2<48),1,"") Mike "Workbook" wrote: I want a €œ1€ to appear in cell N2 if in cell M2 I have greater than 24 but less than 48. This is the IF statement that I have so far in cell N2. =IF(Sheet1!M2=25,1,""). What do you think? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Using IF statement to evaluate Greater or Less than Conditions | Excel Discussion (Misc queries) | |||
| Greater Than/Less Than Question (IF statement?) | Excel Worksheet Functions | |||
| IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT | Excel Worksheet Functions | |||
| Nested If statement to find greater than but less than numbers | Excel Worksheet Functions | |||
Linear Mode
