Trying to get difference...

[MaraMara]

I'm trying to figure out a formula that will display the difference between numbers in a particular set..

I don't know if you can declare variables..
I want A = any whole number between 3-5 , B = any whole number between 6-9, C = any whole number between 10-12

I also have a button that will choose a random number between 3-12.
Say the random number is 7..
Group A would then result in -2 because A's highest value is 5 and 7-5=2.
Group B would have no effect because 7 falls within B's criteria of 6-9
Group C would have no effect either since it's more than 7.

Basically I want to add a penalty equal to the difference between the random number and the highest number in the set that is less than it.

I hope that makes sense... :/

[:) Sixthsense :)]

Change A1 in the below formula to your Random Number Cell

=SUBSTITUTE(TRIM(IF(A1>5,"A="&A1-5&" ","")&IF(A1>9,"B="&A1-9&" ","")&IF(A1>12,"C="&A1-12&" ",""))," ",", ")