ExcelBanter - Larger than X

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Larger than X - Smaller than Y (https://www.excelbanter.com/excel-programming/382903-larger-than-x-smaller-than-y.html)

amirstal

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)?

SteveW

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)?

Fred Smith

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)?

Gary''s Student

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)?

All times are GMT +1. The time now is 09:28 PM.