View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joemc911 joemc911 is offline
external usenet poster
 
Posts: 12
Default Count based on cell value between two numbers

Perhaps for the more experienced this is easy. I hope so.

I want to build a sheet that scores a point value based on data entered in
one cell. I would like to score a point for any number between 1 and 20, two
points for any number between 21 and 40, etc... I imagine it's some version
of an IF formula but I can't seem to figure it out.

Any help would be appreciated. Thanks in advance!