| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Larger than X - Smaller than Y
How can I get the IF function to return any number that is larger than
1 and smaller than 10 (1<X<10)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Larger than X - Smaller than Y
=if(and(x1,x<10),x,"whatever")
Steve On Fri, 09 Feb 2007 14:01:49 -0000, amirstal wrote: How can I get the IF function to return any number that is larger than 1 and smaller than 10 (1<X<10)? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Larger than X - Smaller than Y
=if(and(x1,x<10),true,false)
-- Regards, Fred "amirstal" wrote in message oups.com... How can I get the IF function to return any number that is larger than 1 and smaller than 10 (1<X<10)? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Larger than X - Smaller than Y
=IF(AND(F131,F13<10),F13,"outside")
-- Gary's Student gsnu200705 "amirstal" wrote: How can I get the IF function to return any number that is larger than 1 and smaller than 10 (1<X<10)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distribute values over larger (smaller) range | Excel Discussion (Misc queries) | |||
| Smaller worksheet | New Users to Excel | |||
| Creating smaller and larger cells on the same sheet | Excel Discussion (Misc queries) | |||
| can this be made smaller? | Excel Discussion (Misc queries) | |||
| I need smaller code. | Excel Programming | |||
Linear Mode
