Excel: Between 2 numbers??

[flaviooooo]

Hi,

I was trying a simple formula, but can't find it in excel??

I have a field containing a number, and then another cell with a formula based on the number:

if the number is between 1 and 10 -> A, else -> B

But it appears BETWEEN doesn't exist in exel, like it does in Access..
Any ideas??

 

[SQLBI]

Hi,

I think this is what you're looking for.

=IF(AND(A1>=1,A1<=10),&quot;A&quot;,&quot;B&quot;)

Hope this helps.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[jonsi]

flavioooo

Can you use the AND worksheet function to achieve the same thing

example:

A1 contains a result. Anything greater than Zero but Less than 20 in A1 will return 15 in B1. Anything over 20 in A1 will return 25 in B1.

The formula in B1 will be =IF((AND(A1>0,A1<20)),15,25)

hwyl
Jonsi B-)
&quot;We live in a society exquisitely dependent on science & technology, in which hardly anyone knows anything about science & technology&quot;

 

[flaviooooo]

yeah, that would work thanks

Just find it extremely weird there is no direct function to achieve this