View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
koba
 
Posts: n/a
Default Basic if formula


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