Hi What is the formula to get the following

Mark Points
90 & more 4
85 & less 90 3.7
82.5 & less 85 3.3
77.5 & less 82.5 3
75 & less 77.5 2.7
67.5 & less 75 2.3
67.5 & less 72.5 2
65 & lees 67.5 1.7
62.5 & less 65 1.3
60 & less 62.5 1
less 60 0
I mean when I put the mark in A1 cell the point appear in B1 cell
many thanks

EggHeadCafe - Software Developer Portal of Choice
Run the command or application in the Security context of specified user
http://www.eggheadcafe.com/tutorials...or-applic.aspx