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

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
HIS


"koba" wrote in message
...

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

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


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=522859

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

=1+(A110)+(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