Basic if formula

[koba]

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

[Nick Hodge]

Koba

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

=IF(A1="","",IF(A1<=10,1,IF(A1<=20,2,3)))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"koba" <[email protected]> wrote in message
news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=28639
> View this thread: http://www.excelforum.com/showthread...hreadid=522859
>

[koba]

thanks!!!!!!!!!!!!!!

[Sloth]

Since you have 1, 2, and 3 as the result, you can "cheat".

=1+(A1>10)+(A1>=21)

"koba" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=28639
> View this thread: http://www.excelforum.com/showthread...hreadid=522859
>
>