software

Hi all

Basic if problem but i cant work it out, if a1 is equal to or smaller
than 10 than display 1, or if a1 is between 11 and 20 display 2,
otherwise if it is greater than or equal to 21 display 3.

Thanks your help is appreciated in creating a formula for this problem

koba--
koba
------------------------------------------------------------------------
koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=522859Koba

I added a clause if te cell is blank to show nothing too

=IF(A1=quot;quot;,quot;quot;,IF(A1lt;=10,1,IF(A1lt;=20,2,3)))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;kobaquot; gt; wrote in message
...
gt;
gt; Hi all
gt;
gt; Basic if problem but i cant work it out, if a1 is equal to or smaller
gt; than 10 than display 1, or if a1 is between 11 and 20 display 2,
gt; otherwise if it is greater than or equal to 21 display 3.
gt;
gt; Thanks your help is appreciated in creating a formula for this problem
gt;
gt; koba
gt;
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=522859
gt;

thanks!!!!!!!!!!!!!!--
koba
------------------------------------------------------------------------
koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=522859Since you have 1, 2, and 3 as the result, you can quot;cheatquot;.

=1 (A1gt;10) (A1gt;=21)

quot;kobaquot; wrote:

gt;
gt; Hi all
gt;
gt; Basic if problem but i cant work it out, if a1 is equal to or smaller
gt; than 10 than display 1, or if a1 is between 11 and 20 display 2,
gt; otherwise if it is greater than or equal to 21 display 3.
gt;
gt; Thanks your help is appreciated in creating a formula for this problem
gt;
gt; koba
gt;
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=522859
gt;
gt;