AnsweredAssumed Answered

Performing a calculation based on a range of numbers

Question asked by snkm on Feb 2, 2009
Latest reply on Apr 29, 2010 by comment_1

Title

Performing a calculation based on a range of numbers

Post

I've been unsuccessfully trying to find an answer to my problem, and I'm beginning to pull my hair out!!!  :) 

 

This seems so easy to, but I can't wrap my little blonde brain around it.  Basically, I need a score of (0-5) to be auto entered into (field B) based on the percentage that appear in (field A) 

 

Example:

 

If (field A) is 0% then (field B) = 0

If (field A) is between   1% and 29% then (field B) should = 1

If (field A) is between 30% and 49% then (field B) should = 2

If (field A) is between 50% and 64% then (field B) should = 3

If (field A) is between 65% and 99% then (field B) should = 4

If (field A) is 100% then (field B) should =5

 

Please help me ASAP.  Thanks all.

 

 

 

 

 

 

Outcomes