J
joemc911
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!
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!